0.20.3
-
🎉 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
fromtoDriver()
method in addition to thedriverData
type from generic.