- New ColumnType and Generated interfaces for defining separate interfaces for
select
,insert
and update operations. See the example in the readme for more info.
Breaking changes
- The
db.migrate
module has been removed. You now need to create an instance of Migrator instead. - The new
Generated
interface removes the need fordb.generated
which has now been removed. Simply mark your db-generated columns withGenerated<T>
in the table interface and removedb.generated
.
Before:
interface Person {
id: number,
first_name: string
}
await db.insertInto('person').values({
id: db.generated,
first_name: 'Jennifer'
})
Now:
interface PersonTable {
id: Generated<number>,
first_name: string
}
type Person = Selectable<PersonTable>
await db.insertInto('person').values({
first_name: 'Jennifer'
})