Azure SQL Parser for Java

Azure SQL that GSP parses

CREATE EXTERNAL TABLE ClickStream (
  url varchar(50), event_date date, user_ip varchar(50)
) WITH (
  LOCATION='/webdata/events.csv',
  DATA_SOURCE=analytics_source,
  FILE_FORMAT=csv_format
);

Parse it in Java

import gudusoft.gsqlparser.*;

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

Java edition only. The .NET library has no Azure SQL grammar, so this dialect cannot be parsed from C# or VB.NET. See the .NET SQL Parser SDK for the dialects it does cover.

What GSP handles in Azure SQL

• CREATE EXTERNAL TABLE with LOCATION, DATA_SOURCE, and FILE_FORMAT options
• CREATE DATABASE with Azure EDITION, SERVICE_OBJECTIVE, elastic pool, and WITH LEDGER = ON clauses
• CREATE DATABASE ... AS COPY OF database-copy syntax
• COPY INTO bulk load with WITH (...) options
• CREATE MASTER KEY and database-scoped credentials for external data access
• The complete T-SQL surface: MERGE with OUTPUT, PIVOT/UNPIVOT, CTEs, window functions
• Procedural SQL: Azure SQL stored procedures, functions, triggers, and T-SQL batch scripts — the same procedural engine as SQL Server

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