Salesforce SOQL Parser for Java

Salesforce SOQL queries that GSP parses

SELECT Account.Name, COUNT(Id)
FROM Contact
WHERE CreatedDate = THIS_YEAR
GROUP BY Account.Name
HAVING COUNT(Id) > 5;

Parse it in Java

import gudusoft.gsqlparser.*;

TGSqlParser parser = new TGSqlParser(EDbVendor.dbvsoql);
parser.sqltext = sql; // the Salesforce SOQL query 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 Salesforce SOQL 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 Salesforce SOQL

• Parent-to-child and child-to-parent relationship queries
• TYPEOF polymorphic field selection
• GROUP BY ROLLUP and CUBE with GROUPING()
• Relative date literals such as LAST_N_DAYS:n
• USING SCOPE and WITH DATA CATEGORY filters
• sObject-targeted SELECT queries
• Offline validation of SOQL embedded in Apex code

Beyond parsing, the same AST powers table/column extraction, validation, formatting, and rewriting for Salesforce SOQL.