Drizzle ORM Release Notes & Changelog

ORM

• [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 :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.

…

• Warn about silent migration skips on drizzle-kit checks - thanks @shaneikennedy

New Netlify DB Driver

Note: The Netlify DB driver is developed and maintained by the Netlify team.

Installation:

Usage example:

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)
• Fixed Subquery fields' columns' codecs not being applied to subquery
• Fixed broken in rc.3 db.select in bun-sql/pg driver (fixes #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

…

v1.0.0-rc.3

Porting all the changes that were made in PostgreSQL to other dialects. This release is about MySQL:

• Removed RQBv1 from mysql dialect (._query)
• Internal MySQL sessions refactoring and moving to a unified query preparation function
• Fallback to regular queries on iterators for drivers that don't support streaming instead of throwing an error for compatibility
• Enabled optimized non-jit mappers for regular queries for MySQL dialect
• Switched RQBv2 to array mode querying, disabled root query level JSON conversions

…

v1.0.0-rc.1

⚠️ This release introduced a breaking change into our casing API(see below) and removes RQB v1 ._query for postgres

JIT mappers

Drizzle ORM now has an opt-in API for JIT(just in time compilated) mappers which make most expensive part of the db request pipeline(row mapping) as fast as humanly possible.

We've reworked internals of Drizzle ORM with the new system of codecs. Those are now in charge of normalising responses and requests for diffrent drivers across pg dialect. They helped us not only properly fix a set of data mapping issues but also massively improve performance by not

…

Updates

• Disabled default codec type selectors for custom columns (fixes #5711)
• Сallback type overload for codec selector in custom pg columns (codec: (config) => config?.withTimeZone ? 'timestamptz' : 'timestamp')
• Extended list of postgis types for codecs (improvement for #5711)
• Updated codecs: geometry -> geometry(point), geometry:tuple -> geometry(point):tuple
• Switched PG transactions from class properties back to class methods (fixes #5709)
• Updated AWS Data Api codecs, removed query typings, improved input param mapping
• Removed prepared query typings field from all builders

…

Bug fixed

• drizzle-kit generate fails to generate correct migrations.js file on Windows
• [BUG]: MSSQL real() column returns imprecise float64 values -- missing mapFromDriverValue
• Object key collision
• [BUG]:beta20 Migration to Cloudflare D1 fails
• [BUG]: drizzle-kit migrate: migration SQL failures exit with code 1 but print no error (MigrateProgress hides rejection)
• [BUG]: MS SQL Filtered Index - Drizzle Kit incorrectly generates fully qualified column name in WHERE clause
• [BUG]: [Drizzle-kit][Pg] Altering a UNIQUE constraint: generated SQL ignores the new changes

…

More fixes for the drizzle-kit migration process and commutativity checks

• Adding a value to a PostgreSQL enum will no longer be treated as commutative
• Enum values added in different leaves will now be merged properly