General SQL Parser Java Version

General SQL Parser provides in-depth analysis of SQL script of various databases such as Oracle, SQL Server, DB2, MySQL and Access at a detail level that would not be possible without a complete, 100% compatible query parser.

Parsing SQL is a notoriously difficult task because the syntax of SQL of different databases is very ambiguous in a lot of places. Many people have attempted to write a full SQL grammar with parser generate tool and failed.

Now you can fully incorporated this Java SQL parser into your product set, adds powerful sql processing capability to your program, including offline SQL syntax check, beautify complex sql code with lots of customizable format options, identify various database objects such as table, column, constraints in sql scripts, modify and rebuild sql on the fly, translate sql expression into a binary expression tree that ready for your further processing such as creating filter, and you can take full control of SQL with detailed parse tree of the whole input sql.

This Java version of general sql parser is still in beta version. In the meantime, thoughout the development process, we'll be running a public beta program to ensure that the Java version meets the needs of the database developers. We anticipate providing frequent, regular updates to the beta in order to support the rich back-and-forth interaction that comes with building a user-driven application. Sign up beta now.

You can check some available demos here to see what this library can do for you.

Available features overview

• Offline query syntax check, given the error token, position and hint message.
• Fetch all tables and columns in SQL script.
• Get all SQL statements with type and fragment information in SQL script.
• Tokenize SQL script, easy to check identifier, keyword, operator, constants, comment and special characters.