●Change8

Migrating to Drizzle ORM 0.41.0

Version 0.41.0 introduces 2 breaking changes. This guide details how to update your code.

Released: 3/21/2025

2
Breaking Changes
3
Migration Steps
10
Affected Symbols

⚠️ Check Your Code

If you use any of these symbols, you need to read this guide:

sql-js.free()decimalnumericvarcharbinaryvarbinaryisConfigRQBv1blob

Breaking Changes

●Issue #1

Changed sql-js behavior to use query prebuild instead of database-side prepare. The .free() method has been removed and is no longer needed to manage memory for prepared queries.

●Issue #2

Removed internal mapping for specific Postgres array types (numeric[], timestamp[], timestamp_with_timezone[], interval[], date[]) to prevent precision loss, which may change how these types are returned.

Migration Steps

  1. 1
    Remove any calls to the .free() method when using sql-js.
  2. 2
    Ensure length is specified for varchar columns in MySQL and SingleStore configurations.
  3. 3
    Verify handling of Postgres array types (numeric, timestamp, interval, date) as internal driver mapping has been removed.

Release Summary

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.

Need More Details?

View the full release notes and all changes for Drizzle ORM 0.41.0.

View Full Changelog