TL;DR

Drizzle now supports MySQL with improved query performance and compatibility, resolving issues with streaming and result handling.

Breaking

• Removed RQBv1 (legacy query builder) from the MySQL dialect.

New

• Enabled optimized, non-JIT mappers for regular queries in MySQL.
• RQBv2 (query builder) now uses array mode querying for improved efficiency.

Fixes Worth Knowing

• Fixed lastInsertId and affectedRows handling for MySQL proxy drivers.
• Improved compatibility by falling back to regular queries when streaming isn't supported.

TL;DR

Drizzle ORM now correctly escapes identifiers and aliases, resolving a potential SQL injection vulnerability.

Fixes Worth Knowing

Fixed a critical security vulnerability where database identifiers and aliases weren’t properly escaped, potentially allowing SQL injection attacks.

Before You Upgrade

Review your queries and ensure you are using the latest version of Drizzle to benefit from this security fix.

TL;DR

Drizzle ORM now correctly handles custom migration table names and schemas, resolving issues with drizzle-kit push and ensuring migrations work as expected with non-default configurations.

Fixes Worth Knowing

• drizzle-kit push now respects custom migration schemas and table names defined in drizzle.config.
• Fixed a TypeError when findFirst returns no results.
• Corrected issues with foreign key constraint generation for MSSQL (Microsoft SQL Server).
• Improved drizzle-kit pull to generate valid SQL syntax.

TL;DR

Drizzle ORM now supports advanced PostgreSQL, MySQL, and SQLite features like sequences, identity columns, and generated columns, significantly expanding schema definition capabilities and improving compatibility with database best practices.

New

• Generated Columns: Define columns whose values are computed from other columns (PostgreSQL, MySQL, SQLite).
• PostgreSQL Sequences & Identity Columns: Use modern sequence management instead of the deprecated serial type.
• Drizzle Kit Enhancements: Migrations now support the new ORM features, and a --force flag allows auto-acceptance of data-loss statements during push. Migration file prefixes are now customizable.

Fixes Worth Knowing

None.

Before You Upgrade

If using MySQL or SQLite generated columns, be aware of limitations with the drizzle-kit push and generate commands, particularly around modifying stored generated expressions. Review the release notes for specific details.