Skip to content

0.22.0

Compare
Choose a tag to compare
@nene nene released this 09 Jan 14:17
· 418 commits to master since this release

Breaking changes

  • Renamed TruncateStmt.table field to tables which now contains ListExpr
  • Moved ReturningClause and ClusterByClause types from AllSelectClauses to AllOtherClauses
  • Renamed UpsertClause.columns field to conflictTarget
  • Divided MergeStmt to MergeStmt and MergeClause (to accommodate WithClause inside MergeStmt)
  • Renamed MergeActionInsert.values field to clauses

Improved PostgreSQL support

  • Full support for UPDATE statement
    • Support [ONLY] table [*]
    • Support SET col = DEFAULT
    • Support WHERE CURRENT OF clause
  • Full support for DELETE statement
    • Support [ONLY] table [*]
    • Support USING clause
    • Support WHERE CURRENT OF clause
  • Full support for TRUNCATE statement
    • Support [ONLY] table [*]
    • Support multiple tables
    • Support CASCADE/RESTRICT
    • Support RESTART/CONTINUE IDENTITY
  • Full support for MERGE statement
    • Support WITH clause
    • Support [ONLY] table [*]
    • Support OVERRIDING clause
    • Support INSERT DEFAULT VALUES
    • Support DO NOTHING action
  • Almost full support for INSERT statement
    • Support ON CONFLICT clause
    • Support ON CONFLICT (expr)
    • Support ON CONFLICT ON CONSTRAINT
    • Support OVERRIDING clause

Bugfixes

  • Fixed some serious performance regressions, especially when parsing PostgreSQL (#52)
  • YEAR_MONTH keyword is now case-insensitive (like all others)