• Allow custom migration tables and schema #80
• Allow an existing pool instance to be passed to MysqlDialect and PostgresDialect #81

Breaking changes

UpdateQueryBuilder now takes four type arguments instead of three. The second argument is new and is the table that will be updated. The third one is a union of all the tables that can be referred to.

This only affects you if you've been using explicit types.

What's new

• "update set from" queries are now possible because of the from method in UpdateQueryBuilder
• Raw aliases are now possible when using the as method of a raw sql snippet.

• Actually fix #73

• Fix #73

• support starting transactions from single connections

Breaking changes

db.raw has been replaced with the sql template tag. sql is a free function that can be used with or without a Kysely instance.

See the docs for detailed instructions. Here's how you'd replace the most common use cases of the old db.raw:

import { sql } from 'kysely'

// old
db.raw('select first_name from person where id = ?', [id])

// new
sql`select first_name from person where id = ${id}`

import { sql } from 'kysely'

// old
db.raw('select ?? from person', ['first_name'])

// new
sql`select ${sql.ref('first_name')} from person`

import { sql } from 'kysely'

// old
const result = await db.raw('select first_name from person where id = ?', [id]).execute()

// new
const result = await sql`select first_name from person where id = ${id}`.execute(db)

• Added orderBy and limit methods for DeleteQueryBuilder

• Fix bug #62

• Added the getMigrations method for Migrator.

• Add a RawBuilder constructor that can be easily used without a Kysely instance.