Dameng Database SQL Parser for Java

Dameng Database SQL that GSP parses

CREATE OR REPLACE CLASS employee_t NOT FINAL IS
  name VARCHAR2(100);
  MEMBER FUNCTION get_info RETURN VARCHAR2;
END;

Parse it in Java

import gudusoft.gsqlparser.*;

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

• CREATE OR REPLACE PACKAGE specs and bodies
• Dameng-proprietary CREATE CLASS and CREATE HUGE TABLE
• CREATE TYPE AS OBJECT with TYPE BODY methods, VARRAY and TABLE OF collections
• Flashback queries — WHEN TIMESTAMP, AS OF LSN, VERSIONS BETWEEN LSN
• Materialized views and MV logs, including ON PREBUILT TABLE and query-rewrite toggles
• External routines via CREATE LIBRARY and AS LANGUAGE C/CS bodies
• Dameng lexical rules: // comments, Q-quoted strings, 0x hex literals
• Procedural SQL: Dameng PL/SQL — packages, procedures, functions, object type bodies, every trigger form (DML, INSTEAD OF, DDL/system-event, TIMER), and anonymous DECLARE blocks

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

Recent Dameng Database parser updates

• 2026-06-15 [Dameng] Support CREATE [OR REPLACE] PROCEDURE
• 2026-06-11 [Dameng] Fix Q-quote lexing and stale keyword values
• 2026-04-14 [Dameng] Support CREATE [OR REPLACE] PACKAGE BODY

Full history in the release notes.