T-sql Stored Procedure compatibility

[niatos99]

right now i get following errors:
sqlglot.errors.ParseError: Required keyword: 'expression' missing for <class 'sqlglot.expressions.Dot'>
and also this error:
sqlglot.errors.ParseError: Expected table name but got <Token token_type: <TokenType.L_BRACKET: 'L_BRACKET'>,
for a Stored procedure that's running in our database.

the read is set to read='tsql' in your library

i get these error messages on all of my stored procedures that's running in production
The query is extracted from management studio(ssms)

Stored procedure:

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROC [stage].[Transform_Account] AS
BEGIN
--=============================================================================================
--=============================================================================================

DECLARE @CurrentDate VARCHAR(20)
SET @CurrentDate = CONVERT(VARCHAR(20), GETDATE(), 120)

--=========================================================================================
-- Drop the stage table
--=========================================================================================
IF OBJECT_ID('[stage].[AllAcounts]','U') IS NOT NULL 
	DROP TABLE [stage].[AllAcounts];

--=========================================================================================
-- Create the stage table
--=========================================================================================
CREATE TABLE [stage].[AllAcounts]
WITH (DISTRIBUTION = REPLICATE, HEAP)
AS 
-------------------------------------------------------------------------------------------
-- Insert logic
-------------------------------------------------------------------------------------------
SELECT   ColumnA		= AccountKey
		,ColumnB	= ISNULL(canname, 'None')
	   	
		-- DW columns - Required in stage table
		,@CurrentDate AS [DWCreatedDate]
		,@CurrentDate AS [DWModifiedDate]
		,'I' AS [DWModifiedCode]
FROM schemaB.ExternalTable AS ac

--=========================================================================================
-- Rebuild the replicated table
--=========================================================================================
SELECT TOP 1 * FROM [stage].[AllAcounts];

END
GO

[georgesittas]

You need to clean your SQL script so that distinct statements are separated using semicolons, in order to use sqlglot.parse. SQLGlot doesn't understand that the newlines or GO keywords here are used as statement delimiters.