kysely

Removed a magical UnionToIntersection type that made it difficult to write generic helpers.

• Kysely now supports all the features of SQLite on conflict clause (almost all features of the PostgreSQL on conflict clause)

Breaking changes

• All expression methods in the schema module previously took a raw SQL string. Those all now take a db.raw instance instead for consistency.

// Before
db.schema
  .alterTable('person')
  .addCheckConstraint('some_constraint', 'a < b')

// Now
db.schema
  .alterTable('person')
  .addCheckConstraint('some_constraint', db.raw('a < b'))

• onConflictDoNothing and onConflictUpdate methods have been replaced by a single onConflict method.

// Before
db.insertInto('pet').values(pet).onConflictUpdate('name', updates)

// Now
db.insertInto('pet').values(pet).onConflict(
  // Also see the `columns` and `constraint` methods.
  (oc) => oc.column('name').doUpdateSet(updates)
)

// Before
db.insertInto('pet').values(pet).onConflictDoNothing('name')

// Now
db.insertInto('pet').values(pet).onConflict(
  (oc) => oc.column('name').doNothing()
)

• Added migrateTo, migrateUp and migrateDown methods.
• Added unsigned method for creating unsigned integer columns on MySQL.

Breaking changes

• migrateToLatest no longer throws. The error is returned instead. See the return value type documentation for more info.

• Added withRecursive for recursive common table expressions.
• Support node 14. Kysely will support the last two LTS versions from now on.

Make jsdoc comments better accessible by copying them from the interfaces to the implementing classes. This is done automatically as a build step.

• Added support for temporary tables
• Added support for insert into select from queries

Breaking changes

• Renamed the subQuery method to selectFrom.
• Created separate query builders for select, insert, update and delete queries. This is only a breaking change if you have used the QueryBuilder type explicitly.

Support callback subqueries and raw expressions in insert queries:

db.with('jennifer', (db) => db
  .selectFrom('person')
  .where('first_name', '=', 'Jennifer')
  .select(['id', 'first_name'])
  .limit(1)
).insertInto('pet').values({
  id: db.generated,
  owner_id: (eb) => eb.subQuery('jennifer').select('id'),
  name: (eb) => eb.subQuery('jennifer').select('first_name'),
  species: 'cat',
})

Support custom log function:

const db = new Kysely<Database>({
  dialect: new PostgresDialect(postgresConfig),
  log(event) {
    if (event.level === 'query') {
      console.log(event.query.sql)
      console.log(event.query.parameters)
    }
  }
})

Accept a single raw argument in where, having and on statements. For example

where(db.raw('foo between ? and ?', [a, b]))

Implement SQLite introspector.

Added support for SQLite using the better-sqlite3 library.

Breaking changes

• insert queries now return an InsertResult instead of number | undefined
• update queries now return an UpdateResult instead of number
• delete queries now return a DeleteResult instead of number
• Number fields in QueryResult are now of type bigint to support large integers. Also the QueryResult. insertedPrimaryKey field has been renamed to insertId. QueryResult is only returned by completely raw queries like await db.raw('select * from person').

Use performance.now instead of process.hrtime to time query execution.

• Add support for materialized views

Breaking changes

• increments method in the schema module is now called autoIncrement. You need to go through your migrations and use the new method.
• Harmonised operation node flag names. Booleans like isPrimaryKey are now renamed to primaryKey. This only affects you if you've implemented your own plugins that transform the operation node tree.

Added createView and dropView methods to the schema module.

Added operators ||, @@, @@@, !! and <->

Added node 16 requirement to package.json.

Added the && operator.

• Added the error log level.
• Added the withPlugin method.

• Added the call method.
• Added initial minimal query logging.

Added the union and unionAll methods.