KyselyType-safe SQL query builder

function withPets(
  eb: ExpressionBuilder<DB, 'person'>,
) {
  const pets = eb
    .selectFrom('pet')
    .select(['name', 'species'])
    .whereRef('owner_id', '=', 'person.id')
  return jsonArrayFrom(pets).as('pets')
}

const person = await db
  .selectFrom('person')
  .select(['id', 'first_name'])
  .select(withPets)
  .executeTakeFirstOrThrow()