Presto SQL Parser for Java

Presto SQL that GSP parses

SELECT numbers, animals, n, a
FROM (
  VALUES (ARRAY[2, 5], ARRAY['dog', 'cat']),
         (ARRAY[7, 8], ARRAY['cow', 'pig'])
) AS x (numbers, animals)
CROSS JOIN UNNEST(numbers, animals) AS t (n, a);

Parse it in Java

import gudusoft.gsqlparser.*;

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

• UNNEST of arrays and maps
• TABLESAMPLE clauses
• PREPARE / EXECUTE / DESCRIBE INPUT / DESCRIBE OUTPUT
• ARRAY, MAP, and ROW type constructors
• SQL-bodied CREATE FUNCTION user-defined functions and CALL
• Cross-catalog queries, SHOW CATALOGS, and role management statements

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