Home

What is JSqlParser?

JSqlParser parses an SQL statement. Then the result can be accessed in a structured way. The generated Java class hierarchy can be navigated using the Visitor Pattern.

#Modifications This fork is continuously improved. All modifications could be followed at the Release Notes.

Modifications before GitHubs release tagging are listed in the [Older Releases] page.

How it works?

The parser is built using JavaCC. The core JavaCC grammar for SQL has been taken from Guido Draheim's site and has been changed in order to produce a hierarchy of Java classes. Over the time the grammar was extended and now is a combination of the grammars of various database systems. So some (not all) Oracle, MySql, SQLServer, PostgreSQL specific aspects can be parsed.

Maven

To use JSqlParser in a maven project you have to include the following dependency:

<dependency>
    <groupId>com.github.jsqlparser</groupId>
    <artifactId>jsqlparser</artifactId>
    <version>0.9</version>
</dependency>

Examples

Find some examples of JSqlParsers usage.

• Parsing here.

• Building here.

• Simple expression evaluation here

Feel free to provide more examples.