Aller au contenu
verdict:

Drizzle ORM 1.0.0-rc.5

preview

Notes de version

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 · 259 lignes
  1. # ORM
  4. - [BREAKING] Fixed `postgres-js` transparent parsers set by `drizzle()` constructors breaking driver's own serializers for `timestamptz`, `timestamp`, `date`, `time`, `json`, `jsonb` types (fixes #3171, #4426, #5789) paramsInErrors
  5. :exclamation: Any existing workarounds with manual `JSON.stringify(jsonValue)` in raw sql or raw driver calls must be removed to prevent double stringification of JSON params; For array-type JSON params in `sql` use `sql.param(jsonArrayValue)` to avoid it being parsed as value list instead of param.
  6. - [BREAKING] Restricted `undefined` value passed to fields in relational queries' `where` - now throws an error upon encountering `undefined` in filters, added `EmptyFilter` symbol (`import { EmptyFilter } from 'drizzle-orm/relations'`) that can be used as an explicit replacement of `undefined` where possibly absent filter is desired by design rather than possible bug (fixes #5636)
  7. Example:
  8. ```typescript
  9. db.query.users.findMany({ where: { isActive: params.isActive ?? EmptyFilter } })
  10. ```
  11. - [BREAKING] Relation filters without conditions (`{}`, or containing only empty conditions) are now skipped like any other empty filter instead of generating `exists (...)` check of relation's presence - use `true` to filter by relation's presence, `false` - by its absence
  12. Example:
  13. ```typescript
  14. // Previously: `where exists (select * from "posts" ...)`, now: no filter
  15. db.query.users.findMany({ where: { posts: {} } })
  16. // Users with at least one post
  17. db.query.users.findMany({ where: { posts: true } })
  18. ```
  19. - [BREAKING] Updated `postgres` codecs: now generic codecs contain only in-json codecs (mirroring `mysql`), contents of drivers' codecs remain unchanged
  20. - [BREAKING] Switched `pg` `bytea` in-json codecs from `encode(..., 'base64')` casts to decoding `to_json`'s native hex output
  21. - [BREAKING] Made nested select join nullification consider `SQL` field data during nullification
  22. - [BREAKING] Fixed `sqlite` ignoring `.$defaultFn(...)` on insert when `.default(...)` is present
  23. - [BREAKING] Untied `bun-sql/mysql`, `mysql2`, `singlestore` column mapping from connection config, removed forced `bigint` params on their respective configs, replaced with more stable `cast` codecs
  24. - [BREAKING] Reworked `cockroach` column builders to mirror `pg` - now both have same `.array('[][]...')` syntax
  25. - [BREAKING] Moved `View` exports from `drizzle-orm/sql/sql` to `drizzle-orm/view`
  26. - [BREAKING] `getTableUniqueName` no longer prefixes aliased views or tables with their `schema`
  27. - [BREAKING] `getTableUniqueName` no longer sets `public.` prefix for entities without `schema`
  28. - [BREAKING] Updated `View` class: switched to `Table`-like object config for type template, typed `schema` property
  29. - [BREAKING] Updated `withReplicas` (indirectly fixes #4185):
  30. - Now every query goes to primary db by default
  31. - To query replica, explicitly call `db.$replica`
  32. - [BREAKING] Added `withCastCodecs = false` switch to `getSQL()`, `withCastCodecs = true` switch to `toSQL()` of non-relational query builders - now `db.select(...).from(...).getSQL()` emits query without cast codecs by default
  33. - [BREAKING] Reworked `sqlite-proxy`:
  34. - Added `rowMode: 'array' | 'object'` switch for `'all' | 'get'` execute methods
  35. - Dropped `{ rows: Result[] }` callback result wrapping - now expected direct return of expected data
  36. - Replaced `callback`, `batchCallback` with `SqliteProxyExecutors` object - must provide `run`, `all`, `get` handlers & optional `batch` handler
  37. - Dropped `values` execute method due to it being duplicate of array-mode `all`
  38. - Added `TRunResult` type inferrence based on return type of `run` executor, updated `SqliteRemoteDatabase` template with `TRunResult` argument
  39. - Added per-item `rowMode: 'array' | 'object'` to `batch`, `batch` is expected to mirror executors' return types per query
  40. - [BREAKING] Fixed runtime-type expected result mismatch for `get` (`data | undefined` in runtime, `data[]` in types) (fixes #5461, #3394)
  41. - [BREAKING] Fixed `sqlite` `db.get(sql)` return type lacking `| undefined` for queries without returned rows
  42. - [BREAKING] Omitted query `params` from `DrizzleQueryError` by default, added `paramsInErrors` option to `drizzle` constructor to enable query `params` in `DrizzleQueryError` (fixes #5939)
  43. Example:
  44. ```typescript
  45. const db = drizzle({
  46. connection: 'postgres://...',
  47. paramsInErrors: true
  48. })
  49. ```
  50. - [BREAKING] For `mysql`, `postgres`, `cockroach`, `mssql` set RQBv2 to new query build strategy to fix slow query plans (fixes #5245)
  51. Can be opted out of per query via `strategy` switch: `db.query.findMany({ strategy: 'basic' })`
  52. When used, may break direct references to relations in raw SQL syntax `where`, `orderBy`:
  53. ```typescript
  54. // posts with the most comments first
  55. db.query.posts.findMany({
  56. with: { author: true, comments: true },
  57. orderBy: (t, { sql }) => sql`json_array_length("comments"."r") desc, ${t.id}`, // "comments" becomes unreachable due to query nesting
  58. limit: 2,
  59. });
  61. // posts of verified authors
  62. db.query.posts.findMany({
  63. with: { author: true },
  64. where: { RAW: (t, { sql }) => sql`("author"."r"->>'verified')::boolean` }, // "author" becomes unreachable due to query nesting
  65. });
  66. ```
  67. - [BREAKING] Moved `StringChunk`, `commonStringChunks` exports from `drizzle-orm/sql/sql` to `drizzle-orm/sql/common-chunks` (still exported from `drizzle-orm/sql`)
  68. - [BREAKING] Switched RQBv2 build functions to chunk collection: each accepts optional trailing `collectTo: SQLChunk[]` array to push chunks to and returns chunk arrays instead of `SQL`
  69. :exclamation: Chunk arrays embedded into `sql` directly are rendered as value lists - wrap them in `new SQL(chunks)` to use them as query parts
  70. - `relationsFilterToSQL(...).sql`: `SQL | undefined` -> `SQLChunk[] | undefined`, added `collectTo` parameter
  71. - `relationsOrderToSQL(...)`: `SQL | undefined` -> `SQLChunk[] | undefined`, added `collectTo` parameter
  72. - `relationsOrderEntriesToSQL(...)`: replaced `parts: SQL[]` parameter with `collectTo: SQLChunk[]`, `start?: number`; `RelationsOrderSource`'s `from`, `filters` are now `SQLChunk[]`, `SQLChunk[][]`
  73. - `relationExtrasToSQL(...).sql`: `SQL | undefined` -> `SQLChunk[] | undefined`, added `collectTo` parameter
  74. - `relationToSQL(...)`: `{ filter?: SQL; joinCondition?: SQL }` -> `{ filter: SQLChunk[]; joinCondition?: SQLChunk[] }`, added `filterTo`, `joinConditionTo` parameters
  75. - `getTableAsAliasSQL(...)`: `SQL` -> `SQLChunk[]`, added `collectTo` parameter
  76. - [BREAKING] Relational queries are now cached by caches with `all` strategy (`global: true`), opt out per query via `withCache: false`
  77. - [BREAKING] Replaced `DBQueryConfigWithComment` type with `DBQueryConfigRoot` - config of root relational query containing all root-only options (`strategy`, `comment`, `withCache`); dialects' relational query builders accept it with options they don't support omitted
  78. - Updated RQB filters to allow branded types in shortcut-form `eq` filter (fixes #5298)
  79. - Fixed `$onUpdateFn` being executed without need (fixes #5780)
  80. - Fixed `$onUpdateFn` potentially overriding explicit `null`s
  81. - Fixed `zod` schema generator returning `unknown`-templated coerced types (fixes #5659)
  82. - Fixed `mysql2` constructor setting param in potentially undefined mistyped config (fixes #5972)
  83. - Fixed non-jit mapper nullification triggering on single null column (fixes #1603)
  84. - Preserved qualifiers for column chunks of `sql` fields in selection when non-current table's column is referenced (fixes #5734)
  85. - Optimized query building, mapper generation
  86. - Allowed empty returns in callback-style `orderBy`, `extras`, `RAW` of relational queries
  87. - Removed unused `_` field in `RelationsHelperStatic`
  88. - Fixed naming: `isReversed` to `isFilterReversed` in `Relation`
  89. - `objects`, `arrays` `db.execute` modes (`db.all`, `db.get` in `sqlite`) (bypasses #4464)
  90. - Fixed jit mapper nullifying nested selection objects with columns from different tables
  91. - Fixed selection group nullification not triggering on objects with deeply nested fields (joined view or subquery)
  92. - Fixed `geometry`, `geography` & `box` array types data getting reduced to one item due to wrong delimiter used during `pgArray` construction\parsing
  93. - Added delimiter customization to `makePgArray`, `parsePgArray` utilities
  94. - Optional explicit column lists for `db.insert` (workaround for #5001, #5309)
  95. - Usage: `db.insert(users, 'name', 'email').values([{ name: 'First', email: 'first@example.com' }, { name: 'Second', email: 'second@example.com' }])`
  96. - Transaction snapshot support for `pg` dialect
  97. - Fixed `pg` transaction config related errors on empty but present config (fixes #1772)
  98. - Supported transaction config in effect `pg` drivers
  99. - Bump `tursodatabase` library versions
  100. - Supported transaction configs for `tursodatabase` drivers
  101. - Fixed `mysql` transaction options being joined on wrong separator
  102. - Supported `isolationLevel` in `bun-sql/mysql` transactions
  103. - Removed transaction config from `effect-sqlite`, `effect-mysql` due to lack of support in drivers
  104. - Explicit error throws on unsupported transaction configs
  105. - Partial transaction config support for `libsql`, `tidb` drivers
  106. - Improved error messages on unknown fields in RQBv2 selection (fixes #5367)
  107. - Fixed `op-sqlite` transaction being handled as synchronous
  108. - Fixed broken `op-sqlite` query executors (fixes #5936)
  109. - Bumped `op-sqlite` to v17 (fixes #5928)
  110. - Fixed `expo-sqlite` not finalizing prepared statements
  111. - Added `expo-sqlite/async` for async querying (fixes #5240)
  112. - Added local `sha256` hash function as a fallback for cache query hashing in environments without `globalThis.crypto` available
  113. - Fixed dynamic query builders blocking query builder's variable reassignment after applying nullable joins by defaulting to `not-null` behavior on not yet joined column groups in selection (fixes #4232)
  114. - Fixed `bytea` not being included in `pg` table creation callback format column list
  115. - Moved `SQL.usedTables` calculation from constructor to getter
  116. - Fixed false relation name collision error and relational filter misrouting for relation names shadowing `Object.prototype` properties like `constructor` (fixes #6076)
  117. - Updated `neon-http` migrator to automatically rollback failed migrations
  118. - Bump `effect` to `4.0.0` (fixes #6162, #6403, #6412)
  119. - Improved hash for query name generation & query cache key
  120. - Bump `typebox` to `1.2.0` (fixes #5981)
  121. - Fixed internal type errors in built code
  122. - Updated `mssql`, `cockroach`, `singlestore` sessions to new format
  123. - Added missing `lateral` (`apply`), `cross` joins, `insert ... select`, `db.$count` to `mssql`
  124. - Added explicit error on attempt to insert multiple default-only rows in `mssql`
  125. - Fixed `blob` columns on React Native drivers: writes no longer require `Buffer`, `op-sqlite` and `expo-sqlite` reads normalized to `Uint8Array`. Use `blob(...).$type<UInt8Array>()` to override column's type
  126. - Fixed cast codecs being applied to selection fields of inner queries in `pg`, `mysql`
  127. - Fixed double space following `order by` in set operation queries
  128. - Fixed `MSSQL`, `MySQL`, `SingleStore` `serial` types returning different types based on column's value
  129. - Fixed `sqlite` generating `View`,`Subquery` queries with `cast` on `numeric` columns
  130. - Codec system for `sqlite`, `cockroach`, `mssql`, `singlestore`
  131. - Migrated `mssql`, `cockroach` to RQBv2
  132. - Removed redundant `limit 1` from relational `where`, `coalesce` for json arrays in `sqlite` in RQBv2
  133. - Removed RQBv1 `schema` from `DrizzleConfig`
  134. - Fixed `mysql2` not using `codecs` from config over driver's default when provided
  135. - Added delimiter customization to `makeCockroachArray`, `parseCockroachArray` utilities, mirroring their `pg` counterparts
  136. - Fixed `cockroach` `geometry` arrays being unwritable due to wrong delimiter
  137. - Fixed `cockroach` array parser dropping backslashes from string values
  138. - Fixed `cockroach` `int4[]` being parsed to `string[]`
  139. - Added `mapper` caching for queries reused without `.prepare()`
  140. - Fixed table extra config not rejecting unsuitable for field values (fixes #6140)
  141. - Fixed subquery derived from `.$dynamic()` query builder being unusable with `.from`, `.*Join` (fixes #4069)
  142. - Fixed `Placeholder` `value` field described as `declare protected: TValue` instead of `declared protected value: TValue`; Set `name` field to `protected` and marked `getSQL` as `@deprecated` to prevent field from bleeding into relational filters' autocomplete
  143. - Fixed `Subquery.getSQL()` (fixes #2174)
  144. - Fixed relational queries not supporting `Subquery` type fields in `View`s
  145. - Fixed `alias` function returning materialized views typed as regular views
  146. - Added typed `isAlias: boolean` type config property to `View`, `Table` to identify if it was aliased
  147. - Added `isTableAlias`, `getTableSchema` utils, supported `View` in `getTableName` util
  148. - Supported `Subquery` as relational entity in RQBv2:
  149. - `Subquery` must have flat selection, same as `View`
  150. - Every used `Subquery` will be invoked only once in `WITH` section on root level of relational query, every reference will use it's alias
  151. - Same query can't have reference multiple `Subquery` instances with same alias
  152. - Fixed excessive memory consumption on `mysql`, `mssql`, `singlestore` iterators
  153. - Fixed `mysql2` iterators leaving connection un-drained & deadlocked on errors
  154. - Fixed `mysql2` iterators hanging when connection is dropped mid-stream
  155. - Fixed `ExtraConfigColumn.getSQL()` recursing into stack overflow (fixes #6050)
  156. - Fixed `sqlite` dropping `| undefined` from `.get()` return type of `db.update(table).set(...).returning()`
  157. - Fixed `sqlite` dropping `| undefined` from `.get()` return type of `db.insert(table).values(...).returning()` with `.onConflictDoNothing()` or `.onConflictSet({ where: ... })` present, `db.insert(table).select(...).returning()` (fixes #6107)
  158. - Fixed select codecs leaking into builders passed as sql operator argument
  159. - Fixed `undefined` = `null`, `bigint` = mimic `string`, different data view type collisions in `hashQuery` (fixes #5842)
  160. - Fixed concurrent query + cache invalidation run (fixes #5828)
  161. - Fixed cached query invalidation for:
  162. - tables in nested SQL & subqueries
  163. - aliased and `tableCreator`-prefixed tables
  164. - tables defined on schemas
  165. - joined & aliased tables of query builders embedded into raw `sql`
  166. - tables used in filters, selected fields, order clause, set operators, CTE-s
  167. - Added `getCacheKey(table)` util returning the name query cache tracks a table by (`schema.name`, or `name` for tables without schema; aliases resolve to their original tables)
  168. - Fixed `orderBy` of set operations dropping table qualifiers in passed `sql` objects (e.g. `desc(column)`)
  169. - Supported `DSQL` adapters for `postgres-js` (`@aws/aurora-dsql-postgresjs-connector`) - `drizzle-orm/postgres-js/dsql`, `node-postgres` (`@aws/aurora-dsql-node-postgres-connector`) - `drizzle-orm/node-postgres/dsql`
  170. - Fixed param codecs getting applied to inlined params
  171. - Reworked `db.execute` types (fixes #661):
  172. - Plain `db.execute(sql)` - returns union every possible response type by driver
  173. - `db.execute<never>(sql)` - returns rowless response type (i.e. `insert` without `returning`)
  174. - `db.execute<ReturnedObject>` - driver response with rows typed as `ReturnedObject[]`
  175. - Fixed `db.execute<IReturnedObject>(sql)` type template rejecting interfaces
  176. - Typed `effect` drivers' raw `db.execute`, `db.run` (fixes #6382)
  177. - Fixed RQBv2 query config lacking type errors with `typescript@6` and above (fixes #5644, #6383)
  178. - Fixed `mysql` `date` column being affected by server's timezone (fixes #1442)
  179. - Fixed `effect-mysql`, `bun-sql/mysql` drivers losing `time` fraction
  180. - Fixed `SQLiteBigInt` attempting to use `Buffer` in encoder without `Buffer` present in environment (fixes #2043)
  181. - Fixed `durable-sqlite` `db.get(sql)` throwing on queries returning zero or more than one row instead of returning `undefined` or the first row
  182. - Fixed `node-postgres` transaction crashing process if connection is dropped mid-transaction (fixes #6437)
  183. - Fixed `node-postgres` transaction leaking the pool client on `BEGIN` error (fixes #6341)
  184. - Fixed failed transaction `rollback` error replacing the original error that triggered it
  185. - Added ordering by relations to RQBv2:
  186. ```typescript
  187. // Select users sorted by last post
  188. db.query.users.findMany({ orderBy: { posts: { createdAt: 'desc(max)' } } })
  190. // Select users sorted by post count
  191. db.query.users.findMany({ orderBy: { posts: 'asc(count)' } })
  193. // Select admin posts first, sort rest by creation date
  194. db.query.posts.findMany({ orderBy: { author: { isAdmin: 'desc' }, createdAt: 'desc' } })
  195. ```
  196. - Added cache support to RQBv2 via `withCache` switch:
  197. - `true` - cache query
  198. - `false` - never cache query
  199. - `undefined` - cache only with `all` cache strategy
  200. ```typescript
  201. db.query.users.findMany({ with: { posts: true }, withCache: true })
  202. ```
  203. - Fixed `instanceof` not working reliably for `drizzle` classes in monorepos with multiple library instances
  204. - Fixed `aws-data-api/pg`:
  205. - Array params throwing `Unknown type` error - now sent as `pg` array literals
  206. - Object params throwing `Unknown type` error - now sent as JSON with `JSON` type hint
  207. - Multidimensional arrays in results being returned as raw `ArrayValue` objects
  208. - `char(n)` params being truncated to a single character by `::char` cast
  209. - `inet` values gaining full-width netmask (`/32`, `/128`) in results
  210. - `time({ withTimezone: true })` values losing their offset: params were cast to `::time`, results were converted to UTC by Data API
  211. - Fixed `pg` `time({ withTimezone: true })` columns using `time` codecs instead of `timetz` ones
  212. - Fixed [[BUG]: inArray/notInArray empty arrays do not work with SQL Server](https://github.com/drizzle-team/drizzle-orm/issues/5632)
  213. - Fixed [[BUG]: node-postgres pool client is not released when transaction BEGIN rejects](https://github.com/drizzle-team/drizzle-orm/issues/6023)
  214. - Fixed [Batch insert crashes with RangeError when row-count × column-count exceeds ~8 k rows × 15 cols (~120 k params)](https://github.com/drizzle-team/drizzle-orm/issues/5994)
  215. - Fixed [[BUG]: Composition of not and or/and yields compile error](https://github.com/drizzle-team/drizzle-orm/issues/4160)
  216. - Fixed [[BUG]: Negative limit not working in SQLite](https://github.com/drizzle-team/drizzle-orm/issues/2992)
  217. - Fixed [[BUG]: Pooled transaction() leaks the pool client when BEGIN fails (node-postgres / neon-serverless / vercel-postgres)](https://github.com/drizzle-team/drizzle-orm/issues/6241)
  218. - Fixed [[BUG]: node-postgres transaction() leaks the client on a rejected BEGIN and returns broken clients to the pool](https://github.com/drizzle-team/drizzle-orm/issues/6114). [node-postgres: transaction() runs BEGIN before try/finally, leaking the pool client when BEGIN fails](https://github.com/drizzle-team/drizzle-orm/issues/6341)
  220. # Kit:
  222. - FINALLY incremental snapshots. Drizzle kit now stores initial snapshots and all subsequent are stored as structured diffs + metadata for migrations commutativity checks on different branches
  223. - Added support for custom PGLite options (fixes [#2995](https://github.com/drizzle-team/drizzle-orm/issues/2995), [#4476](https://github.com/drizzle-team/drizzle-orm/issues/4476) and [#3222](https://github.com/drizzle-team/drizzle-orm/issues/3222))
  224. - Fixed `defineConfig` allowing fields from every config variant simultaneously
  225. - Fixed [[BUG]: SQLite push glues the table's FOREIGN KEY clause onto a generated-column ALTER ADD, breaking all inserts](https://github.com/drizzle-team/drizzle-orm/issues/6061)
  226. - Fixed [[BUG]: SQLite push table recreate silently drops UNIQUE from a column that also has a plain index](https://github.com/drizzle-team/drizzle-orm/issues/6060)
  227. - Fixed [[BUG]:drizzle-kit generates DROP COLUMN before DROP INDEX causing PostgreSQL error 42704](https://github.com/drizzle-team/drizzle-orm/issues/6045)
  228. - Fixed [[BUG]: false positve detection of schema changes for default values](https://github.com/drizzle-team/drizzle-orm/issues/5569)
  229. - Fixed [[BUG]: drizzle-kit pull rewrites "character" inside public enum type names to "char"](https://github.com/drizzle-team/drizzle-orm/issues/5932)
  230. - Fixed [[BUG]: drizzle-kit pull error when there are comments in a view definition](https://github.com/drizzle-team/drizzle-orm/issues/5964)
  231. - Fixed [[BUG]: Invalid schema default value generated for sequence-based primary keys in Postgres](https://github.com/drizzle-team/drizzle-orm/issues/5413)
  232. - Fixed [Small typo in drizzle-kit/src/index.ts](https://github.com/drizzle-team/drizzle-orm/issues/4736)
  233. - Fixed [[BUG]: drizzle-kit pull reports index_duplicate for valid MSSQL index names reused across tables](https://github.com/drizzle-team/drizzle-orm/issues/5993)
  234. - Fixed [[BUG]: drizzle-kit pull generates many() instead of one() for one-to-one relations (unique FK columns)](https://github.com/drizzle-team/drizzle-orm/issues/5478)
  235. - Fixed [[BUG]: AWS Data API Postgres - incompatibility with latest @aws-sdk/client-rds-data (3.932.0)
  236. ](https://github.com/drizzle-team/drizzle-orm/issues/5050)
  237. - Fixed [[BUG]: Composition of not and or/and yields compile error](https://github.com/drizzle-team/drizzle-orm/issues/4160)
  238. - Fixed [[BUG]: snakeCase.table converts Korean column names to empty identifiers](https://github.com/drizzle-team/drizzle-orm/issues/6082)
  239. - Fixed [[BUG]: Property decimal does not exist on type, when using pgTable in drizzle orm](https://github.com/drizzle-team/drizzle-orm/issues/3059)
  240. - Fixed [Bug: drizzle-kit pull for SQLite Generates Constraints from Comments in Schema](https://github.com/drizzle-team/drizzle-orm/issues/3407)
  241. - Fixed [[BUG]: drizzle-kit pull fails with column_unsupported_unique for unique indexes on text/mediumtext/longtext columns](https://github.com/drizzle-team/drizzle-orm/issues/6047)
  242. - Fixed [[BUG]: drizzle-kit CLI pull/introspect schemaFilters parameter is ignored](https://github.com/drizzle-team/drizzle-orm/issues/3626)
  243. - Fixed [[BUG]: Changing a view to materialized view doesn't generate correct migration](https://github.com/drizzle-team/drizzle-orm/issues/6176)
  244. - Fixed [[BUG]: SQLite incorrectly scaffolds boolean column with drizzle-kit pull](https://github.com/drizzle-team/drizzle-orm/issues/6182)
  245. - Fixed [[BUG]: Introspection fails if SQLite database has a references without column name](https://github.com/drizzle-team/drizzle-orm/issues/3231)
  246. - Fixed [[BUG]: SQLite pull drops or merges CHECK constraints depending on DDL formatting](https://github.com/drizzle-team/drizzle-orm/issues/6195)
  247. - Fixed [[BUG]: SQLite pull reads a partial index's WHERE off the table's DDL, losing real predicates and inventing false ones](https://github.com/drizzle-team/drizzle-orm/issues/6223)
  248. - Fixed [[BUG]: SQLite pull crashes on any expression index, because .on() doesn't filter the keys the line above it does](https://github.com/drizzle-team/drizzle-orm/issues/6237)
  249. - Fixed [[BUG]: drizzle-kit pull generates a many-to-many whose junction table is one of its own endpoints, and drops the one-relations the foreign keys describe](https://github.com/drizzle-team/drizzle-orm/issues/6197)
  250. - Fixed [[BUG]: drizzle-kit push tries to DROP Neon system roles despite provider: "neon"](https://github.com/drizzle-team/drizzle-orm/issues/6105)
  251. - Fixed [[BUG]: drizzle-kit pull generates invalid through relations for composite foreign keys](https://github.com/drizzle-team/drizzle-orm/issues/6100)
  252. - Fixed [[BUG]: drizzle-kit pull: schema and relations disagree on camelCase for acronym columns (CallID → callId vs callID)](https://github.com/drizzle-team/drizzle-orm/issues/6074)
  253. - Fixed [[BUG]: drizzle-kit pull drops single-column PK/FK constraint names from schema.ts (kept nameExplicit in snapshot) — pull→generate demands rename-or-create hints for every legacy-named constraint](https://github.com/drizzle-team/drizzle-orm/issues/6025) + [[BUG]: Drizzle Kit introspection creates different foreign key names than migration](https://github.com/drizzle-team/drizzle-orm/issues/1549)
  254. - Updates in pull relations logic. TS file generates junction tables only when there are no extra columns in this junction table. Fixed [[BUG]: drizzle-kit pull treats domain tables with exactly two foreign keys as junction tables](https://github.com/drizzle-team/drizzle-orm/issues/6253)
  255. - Fixed [[BUG]: drizzle-kit pull fails with a confusing error if the database can't be reached](https://github.com/drizzle-team/drizzle-orm/issues/6362)
  256. - Fixed [[BUG]: drizzle-kit generate drops column alterations when a column with the same name is renamed in another table](https://github.com/drizzle-team/drizzle-orm/issues/6360)
  257. - Updates in `pull` command - migration.sql is no longer has comments when running `pull --init`
  258. - Fixed `drizzle-orm` not being listed as peer dependency
  259. - Fixed dev dependencies being listed as production

voir sur githubdetected 2026-10-22 via npm