note: la synthèse et les notes de version sont en anglais
note: pas de synthèse pour cette release plus ancienne
Nous synthétisons les releases récentes. Les notes de version originales de cette version sont ci-dessous.
release-notesgithub.com/drizzle-team/drizzle-orm · 85 lignes
- # v1.0.0-rc.4
- - Fixed broken `View` types when using `Subquery` in selection
- - Fixed custom types' JSON field API not being applied when column is used as a decoder on `SQL` fields
- - Fixed codecs not getting applied to `SQL` field when `.mapWith(column)` is set (fixes [#5724](https://github.com/drizzle-team/drizzle-orm/issues/5724))
- - Fixed `Subquery` fields' columns' codecs not being applied to subquery
- - Fixed broken in `rc.3` `db.select` in `bun-sql/pg` driver (fixes [#5779](https://github.com/drizzle-team/drizzle-orm/issues/5779))
- - Updated SQLite `db.$count` builder to include `.sync()` executor for sync drivers
- - Removed RQBv1 from `sqlite`, removed RQBv1 `TSchema`, `TFullSchema` arguments from `sqlite` entities' generics
- - Fixed instances of `sqlite` query errors not being wrapped in `DrizzleQueryError` (`db.batch()` excluded due to api incompatibility)
- - Fixed type error on `CockroachArrayBuilder` constructor caused by referencing internal field's type
- - Removed `mapResult` method from `PreparedQuery` interface, removed `mapResult`, `mapBatchResult` from `pg` and `sqlite` raw queries
- - Fixed wrong `bun-sqlite` run result type
- - Switched `sqlite` RQBv2 to array mode
- - Enabled optimized default query mappers for `sqlite`
- - Reworked `sqlite` sessions: replaced per-driver `PreparedQuery` instances with executors passed via sessions, similar to current `postgresql` and `mysql` implementations, moved `useJitMappers` flag handling to dialect
- - Fixed missing `string` overload on `.comment(sqlCommenterComment)` in query builders
- - Supported nested transactions in `@tursodatabase/database`, `@tursodatabase/database-wasm`
- - Added filesytem-less migrator for `@tursodatabase/database-wasm` at `drizzle-orm/tursodatbase/wasm-migrator`
- - Split SQLite into `async`, `effect` versions (`sync` remains subtype of `async`)
- - Removed `SQLiteSyncDialect`, `SQLiteAsyncDialect`, moved generic SQLite `async`\\`sync` migrators to `sqlite-core/async/session` as `migrateSync`, `migrateAsync`
- - Fixed `sqlite` cache using same cache entry for different execute methods
- - Moved `EffectDrizzlePgConfig` to `drizzle-orm/pg-core/effect/utils`
- - Made `cache` field in `EffectCacheShape` optional
- - Split `mysql` into `async`, `effect` versions
- - Added codec system to `mysql`
- - Fixed `mysql` `float` rounding to either 6 digits or double
- - Fixed `mysql` cropping `.000` from `timestamp(3)`
- - Moved subquery mapper selection from `dialect.buildSelection` to `orderSelectedFields`;
- - [`PG`, `MySQL`] Improved codec system in set operators:
- - When different db types are crossed in a union, db casts them to type it deems as closest compatible to all types involved
- - If columns with codecs are set on both sides of union - codec of combined type will apply
- - If only the left-hand side of union has field with codec - left hand side's codec is preserved
- - If left-hand side field is devoid of codecs - field is not processed by codecs;
- - Set operator queries are switched from `[QUERY 1] UNION [QUERY 2]` to `SELECT ... FROM ([QUERY 1] UNION [QUERY 2]) "drizzle_union"` so cast codecs would apply after union's type mutation
- - Retrieved data of union with different types still may be lossy due to db's own conversion
- - Bump required `effect` package versions to `4.0.0-beta.83`
- - Fixed `sql.param` passing `Placeholder` as expected input value to encoder function instead of `Placeholder`'s value type
- - Fixed unguarded `Buffer` reference in `drizzle-orm/effect-schema` that caused error in environments without `Buffer`
- - Fixed `sqlite` `blob` column runtime-type default mode mismatch (fixes [#1064](https://github.com/drizzle-team/drizzle-orm/issues/1064))
- - Improved typed `sql` operator - preserved nullability, inferred initial data type to `mapWith`callback argument, added `.nullable()` method to modify output type with `| null` (fixes [#571](https://github.com/drizzle-team/drizzle-orm/issues/571)):
- ```typescript
- // Before:
- sql<Type | null>`...`.mapWith((v: any) => String(v)) // Output type: string
- // After:
- sql<Type | null>`...`.mapWith((v: Type) => String(v)) // Output type: string | null
- // `.nullable()` method:
- sql`...`.mapWith((v: unknown) => new Type(v)).nullable() // Output type: Type | null
- ```
- - Fixed `generatedByDefaultAsIdentity` columns not being filtered from inserts in runtime in `postgres` dialect
- - Improved `db.insert(table).select(...)`: removed column order match requirement, allowed skipping selection for columns with defaults or nullability (fixes [#3608](https://github.com/drizzle-team/drizzle-orm/issues/3608))
- ## Drivers
- - Updated `@tursodatabase/database`, `@tursodatabase/database-wasm` to v0.6.0, updated session internals for asynchronous prepare on driver side
- - Added `@tursodatabase/serverless` driver support
- - Added `@tursodatabase/sync` driver support
- - Added `@effect/sql-pglite` driver support
- - Added `@effect/sql-sqlite-node` driver support
- - Added `@effect/sql-sqlite-bun` driver support
- - Added `@effect/sql-sqlite-do` driver support
- - Added `@effect/sql-sqlite-wasm` driver support
- - Added `@effect/sql-libsql` driver support
- - Added `@effect/sql-d1` driver support
- - Added `@effect/sql-mysql2` driver support
- - Fixed `@effect/sql-pg` driver returning object response instead of raw response on `db.execute`
- - `pg-proxy`: added dialect config to optional dialect creator callback
- - Fixed postgres pull from failing for non-admin roles (fixes [#5568](https://github.com/drizzle-team/drizzle-orm/issues/5568))
- - Fixed: [[BUG]: [mssql] INSERT includes generatedAlwaysAs (computed) columns in the column list — SQL Server error 271
- ](https://github.com/drizzle-team/drizzle-orm/issues/5881)
- ## Drizzle Kit
- ### Machine-readable output & programmatic SDK
- - Added an `--output text|json` mode to `generate`, `push`, `pull`, `up`, `export`, and `check`. In `json` mode each command emits a typed JSON envelope (status, errors, payloads) for programmatic and agent consumption (see [OUTPUT_MODES.md](https://github.com/drizzle-team/drizzle-orm/blob/v1.0.0-rc.4/drizzle-kit/OUTPUT_MODES.md), [JSON_CONTRACT.md](https://github.com/drizzle-team/drizzle-orm/blob/v1.0.0-rc.4/drizzle-kit/JSON_CONTRACT.md))
- - Shipped a public programmatic SDK at the `drizzle-kit/cli` subpath exposing `generate()`, `push()`, `pull()`, `up()`, `exportSql()`, and `check()` with typed options and results matching the CLI JSON contract (see [SDK.md](https://github.com/drizzle-team/drizzle-orm/blob/v1.0.0-rc.4/drizzle-kit/SDK.md))
- - Auto-detected non-interactive mode (`--output json`, or `--output text` with a non-TTY stdin) no longer renders interactive prompts. Instead, unresolved renames and destructive changes (`confirm_data_loss`) are surfaced as a `missing_hints` envelope (or a missing-decisions report under `text`) and resolved by supplying a structured `hints` array up front via `--hints` / `--hints-file` (see [HINTS.md](https://github.com/drizzle-team/drizzle-orm/blob/v1.0.0-rc.4/drizzle-kit/HINTS.md))
- ### MCP server
- - Added `drizzle-kit mcp`, a Model Context Protocol server over stdio that exposes the migration lifecycle (`generate`, `push`, `check`, `export`, `up`, `pull`) as MCP tools for any MCP-capable AI agent (see [MCP.md](https://github.com/drizzle-team/drizzle-orm/blob/v1.0.0-rc.4/drizzle-kit/MCP.md))
- ### Agent skills
- - Added `drizzle-kit skills`, which installs Drizzle Kit's bundled [Agent Skills](https://skills.sh) into your project for AI coding assistants. Ships 8 skills: `drizzle`, `drizzle-generate`, `drizzle-hints`, `drizzle-migrations`, `drizzle-output-modes`, `drizzle-pull`, `drizzle-push`, and `drizzle-responses-and-errors` (see [`drizzle-kit/skills`](https://github.com/drizzle-team/drizzle-orm/blob/v1.0.0-rc.4/drizzle-kit/skills) folder)