Vertica SQL Parser for Java and .NET

Example

Vertica SQL that GSP parses

CREATE PROJECTION sales_proj AS
SELECT id, region, amt FROM sales
ORDER BY region
SEGMENTED BY HASH(id) ALL NODES;

Parse it in Java

import gudusoft.gsqlparser.*;

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

The .NET edition exposes the same API in C# — see the C# quick start.

Coverage

What GSP handles in Vertica

• CREATE PROJECTION ... AS SELECT
• Flex tables
• Access policies
• Resource pools
• EXPORT TO VERTICA

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

Actively maintained

Recent Vertica parser updates

• 2026-06-02 [Vertica] Parse AUTO_INCREMENT column attribute
• 2026-05-08 [Vertica] Support AND filter and WHERE in MERGE clauses
• 2026-04-05 [Vertica] Parse AS SELECT subquery in CREATE PROJECTION

Full history in the release notes.