Extensions in version 0.9.6
- support for delete with join table
- support for Alter with multiple ADD/DROP expressions
- support for ON DELETE SET NULL for create table
- added AST node support for subselect, withitem, function, case when
- first support for TABLESPACE within CREATE TABLE
- support for SELECT UNIQUE
- first support for date literals like TIMESTAMP'2004-04-30 04:05:34.56'
- support for UPDATE RETURNING
- support for scalar time function, like CURRENT_TIMESTAMP
- support for LEFT SEMI JOIN
- improved top expression
SELECT TOP (? + 1) * FROM MyTable- allowed negative interval expressions like INTERVAL -420 MINUTES.
- support for ALTER VIEW statements
- improved merge statement
- support for non standard syntax > =, < = and < > (with whitespaces between)