- added options to EXPLAIN statement
- preserved input of && and avoid translation to AND
- added multi values in IN expression
- added COMMENT support for ALTER TABLE statement
- added some FOREIGN KEY definition improvments
- allow VALIDATE as column name
- first support for CREATE SCHEMA and DROP SCHEMA
- allow ON as a value in a set statement (
SET myvalue = ON
) - support for ALTER TABLE ONLY mytable ...
- allow foreign key definition in alter statements without referenced columns specification
- allow datatype binary for column definitions
- support for ALTER TABLE COLUMN DROP NOT NULL
- allow order as column name
- support for table function in IN expression
- allow complex expressions within all of a case when statement
- support for parameters in create index statement
- support for integer parameters for ->> and -> JSON expressions
- support for more keywords in following parts of multipart object names (e.g. mytab.select, mytab.create, ...)
- support for OUTER APPLY
- support for WITH(NOLOCK)
- support for VIEW as object name
- functions hold now multipart names
- support for DISABLE as object name
- API change in
ColumnDefinition.setColumnSpecStrings
toColumnDefinition.setColumnSpecs
to better allow the merge betweenAlterExpression.ColumnDataType
andColumnDefinition