drizzle-team/drizzle-orm v1.0.0-beta.12

1.0.0-beta.12

on GitHub

Breaking changes

• .generatedAlwaysAs() know only accepts sql`` and () => sql``

Improvements

Postgresql dialect now have extra schema errors in ts files on generate and push commands:

• table_name_duplicate - duplicate table name across schema
• column_name_duplicate - duplicate column name across table
• enum_name_duplicate - duplicate enum name across schema
• enum_values_duplicate - duplicate values inside enum
• privilege_duplicate - duplicate privilege name
• role_duplicate - duplicate role name
• schema_name_duplicate - duplicate schema name

SQLite dialect now have extra schema errors in ts files on generate and push commands:

• conflict_column - duplicate column name across table
• conflict_fk - duplicate fk name
• conflict_index - duplicate index name
• conflict_pk - duplicate pk name
• table_no_columns - table has no columns

Bug fixes

• [BUG]: drizzle-kit generate silently exits with code 1
• [BUG]:Unable to resolve module node:crypto
• [BUG]: The package at "node_modules/.bun/drizzle-orm@1.0.0-beta.2-6565b14+35e4bda3077d71da/node_modules/drizzle-orm/migrator.js" attempted to import the Node standard library module "node:crypto". It failed because the native React runtime does not include the Node standard library.
• [BUG]: Problem with backslash in check constraint
• [BUG]: drizzle-kit up throws error "Cannot convert undefined or null to object"
• Fixed bun-sqlite db.get(...) returning data in array mode instead of object mode
• Fixed effect-postgres driver ignoring cache config option
• [BUG]: Types do not allow for placeholder usage in onConflictDoUpdate.set
• [BUG]: alias doesn't work with views (Postgres)
• [BUG]: select()...for("...", { of: table }) uses qualified name of table
• [BUG]: arrayContains() generates incorrect SQL parameters for PostgreSQL, leading to operator does not exist: text[] @> record error
• [BUG]: Params not inlined for single-table selects