JSQLParser/JSqlParser jsqlparser-0.9.2

on GitHub

Extensions Release 0.9.2

• first support for user variables

SELECT @col FROM table1

• support for within group expressions, e.g. oracls LISTAGG function

SELECT LISTAGG(col1, '##') WITHIN GROUP (ORDER BY col1) FROM table1

• support for inner with statements

SELECT * FROM (WITH actor AS (SELECT 'a' aid FROM DUAL) SELECT aid FROM actor)

• support for Oracle collections

SELECT * FROM mytable WHERE COL1 = lines(idx).field1

• support for PostgreSQL ANY - array syntax
• introduced additional parameters for create table statements (deparser extended)
• first support for FOR UPDATE

SELECT * FROM user_table FOR UPDATE

UPDATE mytable SET (col) = (SELECT a FROM mytable2)

• partially support SQL Server 2012 and Oracle 12c OFFSET ... FETCH ...