ESM support

• 🎉 Added ESM support! You can now use drizzle-orm in both ESM and CJS environments.
• 🎉 Added code minification and source maps.
• ❗ Removed several nested import paths. Most notably, everything from drizzle-orm/sql and drizzle-orm/expressions should now be imported from drizzle-orm instead.

• Add possibility to have placeholders in .limit() and .offset()

const stmt = db
  .select({
    id: usersTable.id,
    name: usersTable.name,
  })
  .from(usersTable)
  .limit(placeholder('limit'))
  .offset(placeholder('offset'))
  .prepare('stmt');

const result = await stmt.execute({ limit: 1, offset: 1 });

• 🐛 Added verbose error when .values() is called without values (#441)
• 🐛 Fixed nested PG arrays mapping (#460)
• ❗ Removed spread syntax in .values() (#269)
• 🐛 Fixed passing undefined as field value to insert/update (#375)

• 🐛 Fixed query generation when selecting from alias

• 🐛 Pool connections opened for transactions are now closed after the transaction is committed or rolled back

Bugs

🐛 Fix onConflict targets in #475 - thanks @wkunert ❤️

Documentation

Thanks to @tmcw we have started our way to get JSDoc documentation

📄 JSDoc for conditions in #467 - thanks @tmcw ❤️

• 🎉 Added iterator support to mysql2 (sponsored by @rizen ❤). Read more in the docs
• ❗ .prepare() in MySQL no longer requires a name argument

• 🎉 All enum and text enum columns now have a properly typed enumValues property

• 🐛 Fixed multi-level join results (e.g. joining a subquery with a nested join)

• 🐛 Fix migrator function for PostgreSQL

Would suggest to upgrade to this version anyone who is using postgres dialect. 0.23.9 and 0.23.10 are broken for postgresql migrations

• 🐛 Added missing config argument to transactions API
• 🐛 Fixed Postgres and MySQL schema declaration (#427)

Transactions support 🎉

You can now use transactions with all the supported databases and drivers.

node-postgres example:

await db.transaction(async (tx) => {
  await tx.insert(users).values(newUser);
  await tx.update(users).set({ name: 'Mr. Dan' }).where(eq(users.name, 'Dan'));
  await tx.delete(users).where(eq(users.name, 'Dan'));
});

For more information, see transactions docs:

• PostgreSQL
• MySQL
• SQLite

• 🐛 Fixed dates timezone differences for timestamps in Postgres and MySQL (contributed by @AppelBoomHD via #288)

• 🎉 Added INSERT IGNORE support for MySQL (contributed by @FugiTech via #305)

• 🐛 Fixed referencing the selected aliased field in the same query
• 🐛 Fixed decimal column data type in MySQL
• 🐛 Fixed mode autocompletion for integer column in SQLite
• 🐛 Fixed extra parentheses in the generated SQL for the IN operator (#382)
• 🐛 Fixed regression in pgEnum.enumValues type (#358)
• 🎉 Allowed readonly arrays to be passed to pgEnum

• 🐛 Various minor bugfixes

• 🐛 Fixed broken types in Kysely and Knex adapters

• 🎉 Added libSQL support

• 🐛 Rolled back some breaking changes for drizzle-kit

• 🐛 Re-export InferModel from drizzle-orm