drizzle-orm Releases

This is a bug fix release that resolves a certificate generation utility issue in Drizzle Studio, specifically addressing a permissions error that occurred due to the dependency relationship between drizzle-kit and drizzle-studio.

Jan 16, 2025

This update expands file format support to include DOC, TXT, PNG, JPG, and HTML, while also adding boolean and enum field types to schemas.

Jan 14, 2025

This is a minor bug fix release that corrects an issue with incorrect deprecation detection for table declarations in drizzle-orm.

Dec 25, 2024

This release introduces automated schema generation and new file converters/formatters to enhance document processing workflows.

Dec 14, 2024

This release adds support for MySQL index hints (USE INDEX, FORCE INDEX, and IGNORE INDEX) to drizzle-orm, providing developers with fine-grained control over how the MySQL query optimizer selects indexes for query execution.

Dec 13, 2024

This release introduces a new `drizzle-kit export` command that converts drizzle schema definitions into SQL DDL statements, outputting them to the console. This feature facilitates integration with external migration tools like Atlas, with SQL as the default and currently only supported output format.

Dec 13, 2024

This is a minor release that addresses a TypeScript typing improvement for compatibility with the `exactOptionalPropertyTypes` compiler option. The release closes a feature request to add more flexible typing when using this strict TypeScript configuration.

Dec 11, 2024

This major release introduces internal type changes for several PostgreSQL, MySQL, and SQLite column builders, along with complete rewrites of all validator packages (drizzle-zod, drizzle-valibot, drizzle-typebox). The release also includes significant performance improvements including unminified output, reduced bundle footprint, and faster column type detection.

Dec 9, 2024

This release aligns PostgreSQL dialect behavior with other dialects by removing `IF NOT EXISTS`, `$DO`, and similar statements, ensuring incorrect DDL statements properly fail when objects already exist. This change represents the first step toward upcoming migration workflow improvements, Xata migration support, and CockroachDB compatibility.

Dec 9, 2024

Dec 4, 2024

Drizzle ORM 0.37.0 introduces two major additions: the SingleStore dialect for MySQL-compatible databases and the SQLite Durable Objects driver for Cloudflare Workers. This release also includes bug fixes for replica handling and Neon serverless driver authentication issues.

Dec 3, 2024

This release introduces two significant additions to Drizzle: support for the SingleStore database dialect (MySQL-compatible) and a new SQLite Durable Objects driver. Both additions come with configuration examples and links to getting started guides.

Dec 3, 2024

This release introduces `drizzle-seed`, a new package for seeding databases with test data, along with PostgreSQL support for `OVERRIDING SYSTEM VALUE` in inserts and a new `.$withAuth()` API for the Neon HTTP driver. The release also fixes a TypeScript error related to the Neon serverless package.

Nov 22, 2024

This release adds two major SQL features to Drizzle ORM: support for UPDATE ... FROM syntax in PostgreSQL and SQLite, allowing updates to be driven by other tables with join support and returning columns; and support for INSERT INTO ... SELECT across all database dialects, providing multiple ways to insert data from SELECT statements using query builders, callbacks, or SQL template tags.

Nov 15, 2024

This drizzle-orm 0.36.2 release adds support for more types in like/notLike/ilike/notIlike expressions and includes several bug fixes for expo-sqlite compatibility, schema name handling in SQL, and MySQL's $returningId() implementation.

Nov 14, 2024

This is a minor bug fix release (0.28.1) for drizzle-kit that addresses typos in the repository and fixes an issue where the wrong dialect was set in MySQL/SQLite introspect functionality.

Nov 14, 2024

This is a bug fix release addressing 4 issues related to prepared statements, dynamic queries, identity columns, and BigInt type handling. All fixes were contributed by @L-Mario564.

Nov 6, 2024

This drizzle-kit 0.28.0 release focuses on extensive bug fixes across migration handling, type parsing, and SQL generation, along with two minor improvements including an OHM static imports checker and expanded Supabase auth.users schema support.

Nov 6, 2024

This is a bug fix release for drizzle-kit that addresses critical issues with the push command, including undefined property errors and TypeErrors related to Row Level Security (RLS) functionality, particularly when working with Supabase schemas.

Nov 6, 2024

This is a bug fix release for drizzle-kit addressing an issue with RLS (Row Level Security) policies and Views where the view was incorrectly generated as the last clause in the SQL output.

Nov 1, 2024