SQL Server (T-SQL) SQL Parser for Java and .NET

SQL Server (T-SQL) SQL that GSP parses

CREATE PROCEDURE dbo.usp_sync_target @id INT AS
BEGIN TRY
  MERGE dbo.target AS t USING dbo.source AS s ON t.id = s.id
  WHEN MATCHED THEN UPDATE SET t.val = s.val;
END TRY
BEGIN CATCH THROW; END CATCH;

Parse it in Java

import gudusoft.gsqlparser.*;

TGSqlParser parser = new TGSqlParser(EDbVendor.dbvmssql);
parser.sqltext = sql; // the SQL Server (T-SQL) SQL above
if (parser.parse() == 0) {
    System.out.println(parser.sqlstatements.size() + " statement(s) parsed");
} else {
    System.out.println(parser.getErrormessage());
}

Parse it in C#

using gudusoft.gsqlparser;

TGSqlParser parser = new TGSqlParser(EDbVendor.dbvmssql);
parser.sqltext = sql; // the SQL Server (T-SQL) SQL above
if (parser.parse() == 0)
{
    Console.WriteLine(parser.sqlstatements.size() + " statement(s) parsed");
}
else
{
    Console.WriteLine(parser.Errormessage);
}

Same grammar, .NET-idiomatic API — properties instead of Java getters. See the C# quick start or the .NET SQL Parser SDK.

What GSP handles in SQL Server (T-SQL)

• TRY/CATCH blocks
• Dynamic SQL (EXEC) lineage
• MERGE statements
• BULK INSERT and COPY INTO
• Partition functions and schemes
• Procedural SQL: T-SQL stored procedures, functions, triggers, BEGIN...END blocks, TRY/CATCH exception handling, and dynamic SQL (EXEC) with lineage folding

Beyond parsing, the same AST powers table/column extraction, validation, formatting, and column-level lineage for SQL Server (T-SQL).

Recent SQL Server (T-SQL) parser updates

• 2026-06-30 [SQL Server] Don't fail unit on partial-fold dynamic-SQL re-parse
• 2026-06-28 [SQL Server] Resolve dynamic-SQL lineage with parameter bindings
• 2026-06-24 [SQL Server] Fold literal EXEC('<sql>') so it yields lineage

Full history in the release notes.