JSqlParser

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

News

Version 0.9.1 released.

Version 0.9 released.

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

JSqlParser

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.

Contributions

To help JSqlParsers development you are encouraged to provide

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

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

Extensions in the latest SNAPSHOT version 0.9.1

• Simple support for EXECUTE.

EXECUTE myproc 'a', 2, 'b'

• Improved support for select into clause.

SELECT * INTO mytable FROM mytable2

• Improved support for insert table using with clause.

INSERT INTO mytable (mycolumn) WITH a AS (SELECT mycolumn FROM mytable) SELECT mycolumn FROM a

• Support for limit 0 and limit null clause.
• Window functions now allow simple expressions for partition by.
• Support for create table as select syntax:

CREATE TABLE table1 as SELECT col1, col2 FROM table2

• First simple support of postgresqls JSON syntax.

SELECT data->'images'->'thumbnail'->'url' AS thumb FROM instagram

• Included support for returning for insert statements.

INSERT INTO mytable (mycolumn) VALUES ('1') RETURNING id

• Included support for multitable update statements.

UPDATE table1, table2 SET table1.col2 = table2.col2, table2.col3 = 'UPDATED' WHERE table1.col1 = table2.col1

Extensions of JSqlParser releases

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

BUILDING from the sources

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.

Maven Repository

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</version>
</dependency>