Drizzle ORM

This release consolidates all validator packages into the main `drizzle-orm` package, simplifying dependency management. A new integration with Effect Schema is also introduced, alongside a bug fix for SQLite ordering/grouping.

This release updates the migrator to apply all missing database changes and includes numerous bug fixes across SQL generation, introspection, and driver transactions. A key change restricts async function usage within sync driver transactions.

Drizzle Kit now supports top-level await in configuration and schema files, resolving module import errors. The Effect Postgres integration received major API updates to better align with Effect patterns, including configurable logging and caching layers.

This release introduces detailed schema error reporting for PostgreSQL and SQLite dialects during schema generation and push operations. It also resolves several critical bugs related to crypto module resolution, SQL generation, and configuration handling.

This release standardizes timezone handling for PostgreSQL timestamps and significantly improves the stability and correctness of `drizzle-kit` introspection and schema generation, especially for MySQL and complex indexing scenarios. Caching behavior in Pg has also been made explicit.

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.

This release of drizzle-seed introduces column ignoring in refinements, min/max constraints for date/time generators, and automatic Postgres sequence syncing. It also upgrades the default UUID generator to v4 to fix Zod validation errors.

This release focuses on bug fixes for drizzle-kit, specifically improving schema/table recognition in the push/pull commands and fixing a TypeError in findFirst.

This release focuses on bug fixes for drizzle-kit, specifically addressing false positive change detections in schema pushing, JSON key ordering, and Cloudflare D1 compatibility.

This release fixes several critical bugs across PostgreSQL, MSSQL, and MySQL, while introducing significant changes to how SQLite unique constraints and foreign keys are handled in drizzle-kit.

This release focuses on critical bug fixes for drizzle-kit and the migrator, resolving issues with migration ordering on Linux and silent failures during code generation.

This release introduces a mandatory MSSQL snapshot upgrade to version 2 to support SQL expressions in indexes, adds unique constraint support for MySQL index hints, and resolves several critical migration and introspection bugs.

This release fixes a bug in node-postgres transaction handling where pg-native Pool detection would fail in environments that restrict the use of require().

This release introduces support for subqueries in select fields and fixes several driver-specific issues, including pg-native Pool detection and Bun SQL date mapping.

This release focuses on minor bug fixes, including a typo correction and improvements to the build configuration's external dependency handling.

This release introduces MSSQL and CockroachDB support, a complete rewrite of drizzle-kit with a new v3 migration folder structure, and the transition to Relational Query Builder (RQB) v2.

This release fixes a bug in Drizzle Kit where unnecessary DROP SQL commands were generated during schema pushes to PostgreSQL 18.

This release fixes a bug that prevented drizzle-kit/api from being imported correctly within ESM modules.

This release fixes a bug regarding the return value of durable SQLite transactions.

This release introduces the ability to use the $replicas reference within the system configuration.

This release introduces casing support for studio configuration and its associated functions.

This release focuses on stability and compatibility improvements for SQLite, specifically fixing crashes related to blob columns and correcting session method usage.

This release fixes a bug where DrizzleQueryError was not being exported correctly.

This release improves TypeScript type safety for database clients and updates the Neon Auth schema definition to include an updated_at column.

This release fixes a bug in drizzle-kit related to the generation of halfvec, bit, and sparsevec types.

This release introduces internal updates to the Studio context, specifically adding databaseName and packageName properties.

This release includes a bug fix for relations extraction to ensure compatibility with Drizzle Studio.

This release addresses TypeScript type errors encountered when performing joins under certain tsconfig settings.

This release addresses a critical bug that prevented Drizzle ORM from executing within Cloudflare Durable Objects environments.

This release introduces a robust error-handling wrapper called DrizzleQueryError and a new extensible caching module with a native Upstash integration.

This release fixes a bug in drizzle-kit pull that prevented Gel extensions with double-colon schema names from being processed correctly. Users can now include these extensions by updating their schemaFilter configuration.

This release addresses a bug in PostgreSQL schema generation where enum types were being incorrectly typed.

This release introduces lateral join support for multiple dialects and cross joins, while fixing type inference issues and removing unsupported MySQL features.

This release introduces first-class support for TypeScript native enums in PostgreSQL and MySQL, and resolves critical export duplication issues that caused SyntaxErrors in certain environments.

This release improves PostgreSQL Enum DDL migrations by ensuring column default expressions are correctly updated and upgrades esbuild to 0.25.2 to fix security vulnerabilities and bugs.

This release focuses on fixing critical bugs related to Cloudflare D1, specifically addressing local push failures and SQLITE_AUTH errors during migrations.

This release introduces bigint/number modes for decimal types and refactors sql-js query preparation. It includes several data type mismatch fixes for MySQL and Postgres, and resolves issues with AWS Data API and RQBv1.

This update ensures drizzle-orm's neon-http driver is compatible with @neondatabase/serverless version 1.0.0 while maintaining backward compatibility with older versions.

This release introduces support for the Gel dialect, allowing users to query Gel databases using Drizzle ORM and pull schemas via Drizzle Kit while relying on the Gel CLI for migrations.

This release introduces the Gel dialect to Drizzle, allowing users to pull schemas from Gel databases and perform queries using drizzle-orm and gel-js.

This release removes the peer dependency on React to provide more flexibility in package management.

This release renames the internal 'neon_identity' schema to 'neon_auth' to ensure compatibility with the latest Neon Auth features.

This release fixes SQLite onConflict clause stacking and schema prefixing for aliased entities, while adding view support to aliasedTable().

This release addresses two bugs related to MySQL introspection, specifically fixing syntax errors generated during the process and when handling unsigned columns.

This release introduces support for the Bun SQL driver and expands CTE capabilities to include write operations and raw SQL. It also adds Neon Identity schema helpers and resolves several type-related bugs in drizzle-zod.

This release improves SingleStore support by implementing table recreation for unsupported DDL statements and fixes a bug related to index naming conflicts.

This release introduces support for the SingleStore vector type and fixes a bug related to SQL generation for dropping indexes.

This release fixes a permission error in the drizzle-kit dependency related to certificate generation for Drizzle Studio.