Sybase SQL Parser for Java and .NET

Example

Sybase SQL that GSP parses

CREATE PROCEDURE update_dept_count @dept INT AS
BEGIN
  UPDATE dept SET cnt = (SELECT COUNT(*) FROM emp WHERE emp.dept_id = @dept)
  WHERE dept.id = @dept
END

Parse it in Java

import gudusoft.gsqlparser.*;

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

• Stored procedures (T-SQL)
• Watcom IF...THEN...END IF
• WRITETEXT and INSERT BULK
• DUMP TRANSACTION
• ON COMMIT ROWS
• Procedural SQL: Transact-SQL stored procedures and functions with exception handlers, including Sybase IQ procedure bodies and Watcom IF...THEN...END IF

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

Actively maintained

Recent Sybase parser updates

• 2026-07-06 [Sybase] Support empty statements and ON COMMIT ROWS
• 2026-05-29 [Sybase] Support Watcom IF ... THEN ... END IF in procedure bodies
• 2026-05-19 [Sybase] Hook EXCEPTION clause into TBlockSqlNode + TMssqlBlock

Full history in the release notes.