0.33.0

Improved PostgreSQL support

• Support CREATE / ALTER / DROP POLICY (#103)

0.32.0

Improved BigQuery support

• Support GROUP BY ALL clause (#101)

0.31.1

Fixed keyword case-sensitivity bug (#100)

0.31.0

Breaking changes

• Rename grant_stmt to grant_privilege_stmt, within which:
  • rename roles to privileges
  • rename users to roles
  • combine resouceType and resourceName to single field resource, referencing GrantResource node.
• Rename revoke_stmt to revoke_privilege_stmt, within which:
  • rename roles to privileges
  • rename users to roles
  • combine resouceType and resourceName to single field resource, referencing GrantResource node.

Improved PostgreSQL support

• Support GRANT
• Support REVOKE
• Support GRANT & CREATE TRIGGER inside CREATE SCHEMA
• Support CREATE ROLE
• Support ALTER ROLE
• Support DROP ROLE
• Support CREATE/ALTER/DROP GROUP as alias for ROLE
• Support CREATE/ALTER/DROP USER as alias for ROLE
• Support RESET ROLE
• Support SET ROLE
• Support ALTER TRIGGER
• Support DROP TRIGGER
• Support ALTER DOMAIN .. ADD CONSTRAINT NOT NULL
• Support existing transaction syntax for PostgreSQL
• Support END [TRANSACTION | WORK] in PostgreSQL
• Support AND [NO] CHAIN in transactions

0.30.0

New features

• Added acceptUnsupportedGrammar option. See README for details.

0.29.1

Expose DOMAIN and TYPE types as top-level exports.

0.29.0

Breaking changes

• Renamed NamedDataType.nameKw field to .name (2b1e63b)
• Changed the fields of CastOperatorExpr type: (ed61635)
  • expr -> left
  • dataType -> right
  • added operator field with single possible value "::"

PostgreSQL improvements:

• Support CREATE/ALTER/DROP DOMAIN (fully) (#78)
• Support CREATE/ALTER/DROP TYPE (partially) (#78)
• Support chaining of multiple :: cast expressions (#85)
• Support quoted identifiers as :: cast operator parameters (#85)

SQLite improvements:

• Support COLUMN and KEY as identifiers in SQLite (#80)

Other fixes

• Fix some mistakes in type definitions (#76)

0.28.1

Improvements

• Support MySQL set syntax (thanks to YuMuuu) #81

Continuous integration improvements

• Add Prettier check setting (thanks to YuMuuu) #83
• Add Node 18 and 20 to CI (tanks to YuMuuu) #82

0.28.0

Breaking changes

• Use TriggerEventExpr instead of plain TriggerEvent (d5ca16d)
• Extract timeKw from TriggerEvent (9e0d309)
• Extract TriggerTarget from TriggerEvent (d37a94b)
• Rename TriggerCondition to WhenClause (7cd0758)
• Replace CreateTriggerStmt.eachKw and .when fields with .clauses (56a69b4)
• Don't parse unicode escapes in PostgreSQL unicode strings and identifiers (f715a15)

Improved PostgreSQL support

• Support FILTER() in aggregate functions
• Revert an accidental change to row_constructor syntax
• Support PostgreSQL TRIGGER syntax:
  • Support CREATE TRIGGER
  • Support REFERENCING clause in TRIGGER
  • Support trigger timing clause
  • Support trigger FROM clause
  • Support FOR EACH clause
  • Support TRUNCATE event
• Support ALTER PROCEDURE & ALTER FUNCTION
• Support newline-separated strings, E'strings' and U&'strings'
• Support UESCAPE in unicode strings & identifiers
• Support underscores in number literals
• Update keywords list for PostgreSQL 16 (add SYSTEM_USER)

0.27.1

New parameter type: $nr

• The paramTypes option now accepts "$nr", to match parameters in the form of $1, $2, $3