db

Once your database connection is configured, you are able to import it and begin making queries to your db using kysely as your database driver. This means rather than write raw queries, you will have Kysely to help you build queries and provide helpful typescript autocomplete power at a low level.

import db from '../db'

await db()
  .selectAll('users')
  .where('email', 'ilike', '%burpcollaborator%')
  .execute()

Dream enables you to specify a connection when connecting to the db, like so:

await db('replica').selectAll('users').execute()

You can additionally turn any query built in dream to a kysely query by calling #toKysely, like so:

await User.where({ email: ops.ilike('%burpcollaborator%') })
  .toKysely('select')
  .execute()