Java SQL Parser SDK for AST, validation, and lineage

1. Add the dependency

<!-- pom.xml -->
<repositories>
  <repository>
    <id>gudusoft</id>
    <url>https://www.sqlparser.com/maven/</url>
  </repository>
</repositories>

<dependency>
  <groupId>com.gudusoft</groupId>
  <artifactId>gsqlparser</artifactId>
  <version>4.1.6</version>
</dependency>

This is the trial build: it parses statements up to 10,000 characters and refuses anything longer — fine for individual queries, not for a real stored procedure. See below for an evaluation build without the limit. Gradle: add maven { url 'https://www.sqlparser.com/maven/' } and implementation 'com.gudusoft:gsqlparser:4.1.6'.

2. Parse one SQL statement

String sql = "select c.customer_id, sum(o.amount) total " +
             "from customers c join orders o on c.id = o.customer_id " +
             "group by c.customer_id";
TGSqlParser parser = new TGSqlParser(EDbVendor.dbvoracle);
parser.sqltext = sql;
int result = parser.parse();

3. Handle parser errors clearly

if (result != 0) {
  System.out.println(parser.getErrormessage());
  return;
}

4. Inspect AST, tables, columns, and lineage

for (int i = 0; i < parser.sqlstatements.size(); i++) {
  TCustomSqlStatement stmt = parser.sqlstatements.get(i);
  System.out.println(stmt.sqlstatementtype);
  System.out.println(stmt.tables);
  System.out.println(stmt.getResultColumnList());
}