Extensions Release 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 Version 0.9

• Included support for some keyword object names.

SELECT cast, do FROM tableName

• Included support for named primary keys in create table statements.
• Include adapter classes for visitor interfaces to simplify visitor usage.
• included a huge amount of oracle test sqls. There is much room for improvement supporting all oracle syntax specials.
• pivot support for subqueries implemented

SELECT * FROM (SELECT times_purchased, state_code FROM customers t) PIVOT (count(state_code) FOR state_code IN ('NY', 'CT')) ORDER BY times_purchased

• "!=" support corrected to not give "<>" while deparsing
• Improved COUNT(ALL expr) support
• lax test utils implemented
• toString() for window elements corrected
• Character Set support included.

CAST(col2 AS CHAR(255) CHARACTER SET utf8)

Extensions Version 0.8.9

• First multi statements or script support.
• 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"));

Extensions Version 0.8.8

• 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].*';

Extensions Version 0.8.6

• 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;

Extensions Version 0.8.5

• 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.

Extensions Version 0.8.4

• 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)