0.27.0

Breaking changes

• Various changes to AlterActionAddConstraint node to support BigQuery ADD CONSTRAINT IF NOT EXISTS syntax (72dadd1)
• Moved ReindexStmt from AllSqliteNodes to AllIndexNodes (79b68c2)
• Moved IndexSpecification from AllConstraintNodes to AllIndexNodes (2ba172f)
• Moved IndexIncludeClause from AllConstraintNodes to AllIndexNodes to support INCLUDE (...) in CREATE INDEX (bde541a)
• CreateIndexStmt.name field is now optional (e90647d)
• The CreateViewStmt.columns field now contains list of ColumnDefinition nodes instead of just list of Identifier nodes. (1ba2459)

Support for latest BigQuery (as of 31. January 2024)

• PRIMARY KEY constraint
• FOREIGN KEY constraint
• ALTER TABLE .. DROP PRIMARY KEY
• ALTER TABLE .. DROP CONSTRAINT
• NOT ENFORCED modifier in PRIMARY/FOREIGN KEY
• ALTER TABLE .. ADD CONSTRAINT IF NOT EXISTS
• ALTER VIEW .. ALTER COLUMN .. SET OPTIONS()
• OPTIONS() in CREATE VIEW columns list
• CREATE MATERIALIZED VIEW AS REPLICA OF
• VECTOR_SEARCH() function
• CREATE VECTOR INDEX
• GROUPING() function
• GROUP BY .. GROUPING SETS / CUBE / ROLLUP
• quantified LIKE operator

Improved PostgreSQL support

• CREATE INDEX statement
• DROP INDEX statement
• ALTER INDEX statement
• REINDEX statement
• Parameters for opclass (mainly in the context of CREATE INDEX)