Greenplum SQL Parser for Java and .NET

Greenplum SQL that GSP parses

CREATE TABLE sales (id INT, region TEXT, amt NUMERIC)
DISTRIBUTED BY (id);

Need us to check your own Greenplum SQL? Send a sample.

Parse it in Java

import gudusoft.gsqlparser.*;

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

• DISTRIBUTED BY clauses
• External tables
• CREATE FUNCTION bodies
• psql slash commands
• SET variables
• Procedural SQL: PL/pgSQL-style function bodies (CREATE FUNCTION) and DECLARE blocks

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

Recent Greenplum parser updates

• 2026-06-09 [PostgreSQL, Greenplum, Redshift] '/' on a line is division
• 2026-03-13 [Greenplum, Snowflake] Fix syntax parsing issues
• 2026-01-11 Delegate GaussDB and Greenplum parsing to VendorParsers

Full history in the release notes.