data-table-postgres@0.4.0
Breaking Changes📦 remixView on GitHub →
⚠ 2 breaking✨ 1 features🐛 1 fixes🔧 4 symbols
Summary
This release removes deprecated DDL operation methods and introduces a new method for executing SQL scripts, alongside fixing an issue with raw SQL placeholder rewriting.
⚠️ Breaking Changes
- The functions `migrate(request)` and `compileSql(DataMigrationOperation)` have been removed from the adapter because the DDL operation ADT was removed from `@remix-run/data-table`.
- The `compileSql` function now only accepts `DataManipulationOperation`.
Migration Steps
- Replace calls to `migrate(request)` with the appropriate new migration logic.
- Update calls to `compileSql` to only pass `DataManipulationOperation`.
- Use the new `executeScript(sql, transaction?)` method for running SQL-file migrations.
✨ New Features
- SQL-file migrations must now use the new `executeScript(sql, transaction?)` method, which forwards to `client.query(sql)` without a parameter array.
🐛 Bug Fixes
- Fixed raw SQL placeholder rewriting to correctly preserve `?` characters inside string literals, quoted identifiers, comments, and PostgreSQL dollar-quoted strings.