DuckDB SQL Parser for Java

DuckDB SQL that GSP parses

SELECT * FROM cities
PIVOT (SUM(population) FOR year IN (2000, 2010, 2020));

Parse it in Java

import gudusoft.gsqlparser.*;

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

• PIVOT/UNPIVOT statements
• QUALIFY clause
• Lambda and list comprehension
• Struct/map/list literals
• FROM-first syntax and GROUP BY ALL

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

Recent DuckDB parser updates

• 2026-05-17 [PostgreSQL, DuckDB] MERGE WHEN MATCHED THEN DO NOTHING (PG 15+)
• 2026-03-31 [DuckDB] Comprehensive dialect support: PIVOT/UNPIVOT, MACRO, lambdas, QUALIFY, ASOF JOIN, and more

Full history in the release notes.