FLASK _SQLALCHAMY_Microsot SQL Server - Executing Multiline Query

As i was following below tutorial :How To Build Web Applications with Flask Not found any good suggestion on below query.

Want to connect and execute below SQL statement on MS SQL Server (microsoft) from Flask web application.

SQL QUERY 1:
"""
USE [TESTDB]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [INSIM\MY14AT].[TestTable](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[col1] [varchar](10) NULL,
	[col2] [varchar](10) NULL
) ON [PRIMARY]
GO
"""
SQL QUERY 2:
'
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Arun
-- Create date: 2024-04-27
-- Description:	Test SP
-- =============================================
ALTER PROCEDURE dbo.sp_TestSP 
	@p1 VARCHAR(10)
	,@p2 VARCHAR(10)
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
	SELECT * From TestTable where col1=@p1 and col2=@p2
	SELECT * From TestTable where col1=@p1 
END
GO
'
SQL QUERY 3 : Exec sp_TestSP @p1,@p2

• Returns multiple result set. Any suggestion on drivers/plugins and sample code will be well appreciated.

With Thanks, Arun. patro.arun@gmail.com