Skip to content

0.20.3

Compare
Choose a tag to compare
@github-actions github-actions released this 02 Mar 21:11
· 2286 commits to main since this release
6db3980
  • 🎉 Added support for locking clauses in SELECT (SELECT ... FOR UPDATE):

    PostgreSQL

    await db
      .select()
      .from(users)
      .for('update')
      .for('no key update', { of: users })
      .for('no key update', { of: users, skipLocked: true })
      .for('share', { of: users, noWait: true });

    MySQL

    await db.select().from(users).for('update');
    await db.select().from(users).for('share', { skipLocked: true });
    await db.select().from(users).for('update', { noWait: true });
  • 🎉🐛 Custom column types now support returning SQL from toDriver() method in addition to the driverData type from generic.