PostgreSQL compatibility
- Tables no longer create a sequence automatically when no primary key is specified.
- Primary keys are now always required. This is a first step to adding support for SERIAL and BIGSERIAL.
- Support postgres-style parameters
$1,$2,$30, etc. - Removed support for SQLite-style parameters
$? - Support standard quotes for string literals and identifiers
- Renamed
SOUBLEtoDOUBLE PRECISION - Renamed
BLOBtoBYTEA BOOLtype now behaves like in Postgres- Support
nextvalexpression - Add support for
::casts
Misc
- Use Pebble v2.1.0
- Fix prepared statements
- Improve boolean and integer comparison
Full Changelog: v0.17.0...v0.18.0