0.18.0
Breaking changes
columnsfield has been moved frominsert_clauseto newinsert_columns_clause.
This is because MySQL allowspartition_clauseto be optionally placed betweeninsert_clauseand the list of columns.truncateTableKwintruncate_stmthas been replaced withtruncateKwandtableKwfields.
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