●Change8

0.43.0

Breaking Changes
📦 drizzle-orm
⚠ 2 breaking✨ 3 features🐛 4 fixes🔧 7 symbols

Summary

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

⚠️ Breaking Changes

  • Removed .fullJoin() from the MySQL select API as it is not supported by the dialect.
  • Gel columns now always include explicit schema and table prefixes to prevent naming collisions in subqueries.

Migration Steps

  1. Remove any usage of .fullJoin() in MySQL queries as it is no longer available in the API.

✨ New Features

  • Added support for cross join across all dialects.
  • Added lateral left, inner, and cross joins for PostgreSQL, MySQL, Gel, and SingleStore.
  • Added drizzle connection attributes to SingleStore driver instances.

🐛 Bug Fixes

  • Fixed incorrect type inference for insert and update models when using non-strict tsconfig settings.
  • Fixed invalid spelling of the nowait flag.
  • Added missing export for PgTextBuilderInitial type.
  • Removed outdated IfNotImported type check from SingleStore driver initializer.

🔧 Affected Symbols

crossJoinleftJoininnerJoinfullJoinPgTextBuilderInitialSingleStoreDrivernowait