v1.0.0-beta.9
Breaking Changes📦 drizzle-ormView on GitHub →
⚠ 1 breaking✨ 6 features🐛 1 fixes🔧 3 symbols
Summary
This release introduces native Effect SQL driver support and significant type system improvements for PostgreSQL columns. It also updates the `drizzle-kit` loader to `tsx` and switches the default MySQL2 client pool.
⚠️ Breaking Changes
- The postgres `.array()` method is no longer chainable for creating multidimensional arrays. To create multidimensional arrays, use string literals for dimensions, e.g., `.array('[][]')` or `.array('[][][]')`.
Migration Steps
- If using multidimensional arrays in PostgreSQL, change chaining syntax like `.array().array()` to using dimension strings like `.array('[][]')`.
✨ New Features
- Native support for the `@effect/sql-pg` driver.
- Query builder chain now supports both EffectLike and PromiseLike flows.
- Simplified and decoupled `PgColumn` type chain, resulting in better type performance and simpler declaration.
- The `dimensions` property is now available on every `PgColumn` at runtime and in the type chain.
- Migrated `drizzle-kit` loader from `esbuild-register` to `tsx` for seamless ESM and CJS module support.
- Added native Bun and Deno launch support for faster startup times.
🐛 Bug Fixes
- Fixed missing query result recalculation when using dynamic updates with joins in PostgreSQL.