Look here for more information and examples: https://github.com/JSQLParser/JSqlParser/wiki.

JSqlParser is dual licensed under LGPL V2.1 and Apache Software License, Version 2.0.

• Version 0.9.5 released.
• Please test the actual 0.9.5-SNAPSHOT. It includes some grammar refactorings which eventually results in parse tree changes.
• Version 0.9.4 released.
• Please test the actual SNAPSHOT, if there are problems using the extended identifier token.
• Version 0.9.3 released.

More news can be found here: https://github.com/JSQLParser/JSqlParser/wiki/News.

JSqlParser is a SQL statement parser. It translates SQLs in a traversable hierarchy of Java classes. JSqlParser is not limited to one database but provides support for a lot of specials of Oracle, SqlServer, MySQL, PostgreSQL ... To name some, it has support for Oracles join syntax using (+), PostgreSQLs cast syntax using ::, relational operators like != and so on.

If you need help using JSqlParser feel free to file an issue or contact me.

To help JSqlParsers development you are encouraged to provide

• feedback
• bugreports
• pull requests for new features
• improvement requests
• fund new features

Also I would like to know about needed examples or documentation stuff.

• support for ON DELETE SET NULL for create table
• added AST node support for subselect, withitem, function, case when
• first support for TABLESPACE within CREATE TABLE
• support for SELECT UNIQUE
• first support for date literals like TIMESTAMP'2004-04-30 04:05:34.56'
• support for UPDATE RETURNING
• support for scalar time function, like CURRENT_TIMESTAMP
• support for LEFT SEMI JOIN
• improved top expression

SELECT TOP (? + 1) * FROM MyTable

• allowed negative interval expressions like INTERVAL -420 MINUTES.
• support for ALTER VIEW statements
• improved merge statement
• support for non standard syntax > =, < = and < > (with whitespaces between)

• Release Notes
• Modifications before GitHubs release tagging are listed in the Older Releases page.

As the project is a Maven project, building is rather simple by running:

mvn package

This will produce the jsqlparser-VERSION.jar file in the target/ directory.

JSQLParser is deployed at sonatypes open source maven repository. Starting from now I will deploy there. The first snapshot version there will be 0.8.5-SNAPSHOT. To use it this is the repository configuration:

<repositories>
     <repository>
         <id>jsqlparser-snapshots</id>
         <snapshots>
             <enabled>true</enabled>
         </snapshots>
         <url>https://oss.sonatype.org/content/groups/public/</url>
     </repository>
</repositories>

This repositories releases will be synched to maven central. Snapshots remain at sonatype.

And this is the dependency declaration in your pom:

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