Hey 👋

updated_at columns are very common. MySQL supports the ON UPDATE CURRENT_TIMESTAMP shortcut that makes the column value change to current date and time on every record update.

Currently, we don't have a built-in way that supports it.

We have an onUpdate method on the column definition builder, but it only supports foreign key actions as strings.

Users are forced to:

import { sql } from 'kysely'

.addColumn('updated_at', 'datetime', (cb) => cb.modifyEnd(sql`ON UPDATE CURRENT_TIMESTAMP`))

everywhere, this is not ideal.

The easiest would be to add 'CURRENT_TIMESTAMP' to onUpdate's argument type, and parse it differently at runtime - no foreign key related nodes.

Alternatively, we could introduce onUpdateCurrentTimestamp().