0.18.0
Breaking changes
columns
field has been moved frominsert_clause
to newinsert_columns_clause
.
This is because MySQL allowspartition_clause
to be optionally placed betweeninsert_clause
and the list of columns.truncateTableKw
intruncate_stmt
has been replaced withtruncateKw
andtableKw
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