jsqlparser-0.8.4

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)