Teradata SQL Parser for Java and .NET

Teradata SQL that GSP parses

SELECT store_id, sales_amt,
  RANK() OVER (PARTITION BY store_id ORDER BY sales_amt DESC) AS rnk
FROM daily_sales
QUALIFY rnk <= 3;

Parse it in Java

import gudusoft.gsqlparser.*;

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

• QUALIFY clause
• BTEQ scripts
• FastLoad/MultiLoad/FastExport
• COLLECT STATISTICS
• Period predicates (MEETS/PRECEDES)
• Procedural SQL: Stored procedures and triggers plus BTEQ scripts, including FastLoad, MultiLoad, and FastExport utility commands

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

Recent Teradata parser updates

• 2026-06-18 [Teradata] Parse MEETS/PRECEDES/SUCCEEDS period predicates
• 2026-06-05 [Teradata] Support PIVOT DEFAULT ON NULL clause
• 2026-05-25 [Teradata] Allow optional alias in MERGE USING VALUES

Full history in the release notes.