Starstruk Logo MarkStarstruk

0.43.0

drizzle-team/drizzle-orm0.43.0Apr 24, 2025by github-actions[bot]

AI Summary

Release 0.43.0 of drizzle-orm introduces cross join support and lateral joins (left, inner, cross) across PostgreSQL, MySQL, Gel, and SingleStore databases. This release also includes several bug fixes including removal of unsupported full join from MySQL API, type inference corrections for non-strict tsconfigs, and SingleStore driver improvements.

Key Highlights

  • Added cross join support
  • Added lateral left, inner, and cross joins for PostgreSQL, MySQL, Gel, and SingleStore
  • Removed unsupported full join from MySQL select API
  • Fixed incorrect type inference for insert/update models with non-strict tsconfigs
  • Added drizzle connection attributes to SingleStore driver instances

Breaking Changes

  • Removed full join from MySQL select API (was previously added but not supported by the MySQL dialect)

New Features

  • Cross join support
  • Lateral left, inner, and cross joins for PostgreSQL, MySQL, Gel, and SingleStore
  • Drizzle connection attributes for SingleStore driver instances

Full Release Notes

## Features

- Added `cross join` \([#1414](https://github.com/drizzle-team/drizzle-orm/issues/1414)\)
- Added lateral `left`, `inner`, `cross` joins to `PostgreSQL`, `MySQL`, `Gel`, `SingleStore`
- Added drizzle connection attributes to `SingleStore`'s driver instances  

## Fixes

- Removed unsupported by dialect `full join` from `MySQL` select api  
- Forced `Gel` columns to always have explicit schema & table prefixes due to potential errors caused by lack of such prefix in subquery's selection when there's already a column bearing same name in context  
- Added missing export for `PgTextBuilderInitial` type  
- Removed outdated `IfNotImported` type check from `SingleStore` driver initializer  
- Fixed incorrect type inferrence for insert and update models with non-strict `tsconfig`s \([#2654](https://github.com/drizzle-team/drizzle-orm/issues/2654)\)  
- Fixed invalid spelling of `nowait` flag \([#3554](https://github.com/drizzle-team/drizzle-orm/issues/3554)\)
- [Add join lateral support](https://github.com/drizzle-team/drizzle-orm/issues/420)
- [Remove .fullJoin() from MySQL API](https://github.com/drizzle-team/drizzle-orm/issues/1125)