Databricks SQL Parser for Java

Databricks SQL that GSP parses

CONVERT TO DELTA parquet.`/data/events`;
OPTIMIZE events;
RESTORE TABLE events TO VERSION AS OF 8;

Parse it in Java

import gudusoft.gsqlparser.*;

TGSqlParser parser = new TGSqlParser(EDbVendor.dbvdatabricks);
parser.sqltext = sql; // the Databricks 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 Databricks 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 Databricks

• CONVERT TO DELTA
• OPTIMIZE tables
• RESTORE TABLE (time travel)
• Unity Catalog DDL
• GROUP BY ALL

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

Recent Databricks parser updates

• 2026-04-16 [Databricks] Accept bare time units in TIMESTAMPDIFF
• 2026-04-03 [Databricks] Add ODBC escape syntax support
• 2026-01-22 Add Databricks GROUP BY ALL HAVING clause support

Full history in the release notes.