Version 0.8.8 released.

Due to incompatibilities using maven release with git v1.8.5 I skipped version 0.8.7. So the actual released version is 0.8.8.

Recent changes in 0.8.7-SNAPSHOT for some alias support changes introducing some API changes.

Version 0.8.6 released.

The first release version 0.8.5 is available at maven central (http://repo1.maven.org/maven2/) and at repository https://oss.sonatype.org/content/groups/public/.

The maven repository settings have been changed. Version 0.8.5-SNAPSHOT will be the first snapshot at sonatypes open source repository location. The following releases will go there as well and published to maven central. To avoid problems with the original projects artifacts the groupid was changed to com.github.jsqlparser. You will find configuration details below.

JSqlParser parses an SQL statement and translate it into a hierarchy of Java classes. The generated hierarchy can be navigated using the Visitor Pattern.

• Backported window option from fork to analytic expression.
• Added NULLS FIRST and NULLS LAST to order by.
• Improved parsing of top.
• Improved support for multi part names (SQLServer)
• Better support for signed expressions. The sign is stored in the parse tree.

SELECT +col, -col FROM mytable

• Added CCJSqlParserUtil.parseExpression to parse a simple expression. Now you can build expressions from a String like "a+b".

Expression expr = CCJSqlParserUtil.parseExpression("a*(5+mycolumn)");

• Improved SelectUtils to build simple select statements.

Select select = SelectUtils.buildSelectFromTable(new Table("mytable"));

• Startet a simple utility class SelectUtils to collect basic select modification tools.
  • addExpression adds a new expression to the select list.
  • addJoin adds a new join to the select.
• Added support for optional " AS " for aliases.

SELECT * FROM mytable myalias

• Added first support for ALTER TABLE statements

ALTER TABLE mytable ADD COLUMN mycolumn varchar (255)

• Added support for PostgreSQL regular expression match operators.

SELECT a, b FROM foo WHERE a ~ '[help].*';
SELECT a, b FROM foo WHERE a ~* '[help].*';
SELECT a, b FROM foo WHERE a !~ '[help].*';
SELECT a, b FROM foo WHERE a !~* '[help].*';

• Added first support for Oracle hierarchical queries

SELECT * FROM employees CONNECT BY employee_id = manager_id ORDER BY last_name;
SELECT * FROM employees START WITH employee_id = 100 CONNECT BY PRIOR employee_id = manager_id ORDER SIBLINGS BY last_name;

• Added support for mysql truncate function
• Changed repository location and groupid of JSqlParsers artifact.

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

• Added support for postgresql type character varying.

• Added support for named JDBC parameters

SELECT * FROM mytable WHERE b = :param

• Added support for pivot expressions
• Added support for boolean functions in where statements

select * from my_table where bool_func(col)

• Added support for Oracles old join syntax for more compare operations

select * from taba, tabb where taba.a<tabb.a(+)

• Added support for foreign keys in create table statements

create table testTable1 (a varchar(10), b varchar(20), foreign key a references testTable2(a))
create table testTable1 (a varchar(10), b varchar(20), constraint fkIdx foreign key a references testTable2(a))

• Added support for simple intervals

select 5 - INTERVAL '45 MINUTE' from mytable

• Added support for multi values IN expression

select * from mytable where (a,b,c) in (select a,b,c from mytable2)

• Added support for cross join
• Allowed complex expressions in extract from
• Corrected cast expression to make type parameters usable (e.g. cast(col1 as varchar(255))
• Added support for column comma list in partition by statements
• Added support for columns names in create view statements

create view testView (col1,col2) as select a, b from table

• Added support for column cast using ::
• Added support for from clause in update statements

update tab1 set c=5 from tab1 inner join tab2 on tab1.col1=tab2.col2

• Corrected TableNamesFinder to work with update statements additions.
• Added support for simple create materialized view statements without additional parameters.

create materialized view testView as select a, b from table

• Added support for simple create index statements

create index myindex on mytab (mycol, mycol2)

• Changed project tests to junit 4
• Changed project layout to maven project
• Added regexp (REGEXP) operator
• Added support for SELECT without FROM (e.g. "SELECT 1+2")
• Moved parser from using StringBuffer to using StringBuilder
• Added support for CAST expression

select cast(col as varchar) from table

• Added support for modulo (a % b)
• Added support for brackets quotation
• Added support for NOT expr IS (expr IS NOT was already supported)
• Added support for Oracles (+) Join Syntax

select * from taba, tabb where taba.a=tabb.a(+)

• Added alias visitor to add aliases to selections
• Added connect visitor
• TableNamesFinder moved from tests to main source
• Added proper support for sets (union, intersect)

select a from taba union select b from tabb
select a from taba intersect select b from tabb
select a from taba except select b from tabb
select a from taba minus select b from tabb

• Added support for extract(year from datetime-expr)
• Start implementation of analytical expressions
• merged support for CREATE VIEW
• Added lateral subquery support
• Added support for multi values insert statement

insert taba (col1,col2) values (1,2), (2,5), (3,20)

• Added support for multi values in select statement

SELECT col FROM (VALUES 1,2) AS MY_TABLE(col)

• Added extended support for analytic expressions (empty over clause, parameter within aggregat function)

SELECT sum(a) over () FROM taba

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

This is a fork of the jsqlparser originally developed by ultimoamore.

Original project websites:

• http://jsqlparser.sourceforge.net
• http://sourceforge.net/projects/jsqlparser/