Skip to content

0.18.0

Compare
Choose a tag to compare
@nene nene released this 30 Oct 09:02
· 678 commits to master since this release

Breaking changes

  • columns field has been moved from insert_clause to new insert_columns_clause.
    This is because MySQL allows partition_clause to be optionally placed between insert_clause and the list of columns.
  • truncateTableKw in truncate_stmt has been replaced with truncateKw and tableKw fields.

Improved MySQL/MariaDB support

  • Support INSERT..SET
  • Support PARTITION clause in INSERT
  • Support TABLE statements
  • Support ON DUPLICATE KEY UPDATE clause
  • Support row and columns aliases in INSERT
  • Support VALUES() function
  • Support RENAME TABLE statement
  • Support basic ALTER VIEW
  • Support unicode and $ in identifiers
  • Allow identifiers to start with $

Initial PostgeSQL support

Experimental support for Postgres. This is really more on the level of "please don't use it".

  • double-quoted identifiers
  • HEX numbers
  • Basic Postgres strings
  • basic INSERT statement
  • For now support the same data types as SQLite
  • Basic transactions
  • unicode and $ in identifiers
  • binary numbers
  • octal numbers
  • Basic array literals