Function: jsonArrayFrom()

function jsonArrayFrom<O>(expr): RawBuilder<Simplify<O>[]>;

import { kysely } from "@evolu/common";

// TODO: Update for Evolu
const result = await db
  .selectFrom("person")
  .select((eb) => [
    "id",
    kysely
      .jsonArrayFrom(
        eb
          .selectFrom("pet")
          .select(["pet.id as pet_id", "pet.name"])
          .whereRef("pet.owner_id", "=", "person.id")
          .orderBy("pet.name"),
      )
      .as("pets"),
  ])
  .execute();

result[0]?.id;
result[0]?.pets[0].pet_id;
result[0]?.pets[0].name;

select "id", (
  select coalesce(json_group_array(json_object(
    'pet_id', "agg"."pet_id",
    'name', "agg"."name"
  )), '[]') from (
    select "pet"."id" as "pet_id", "pet"."name"
    from "pet"
    where "pet"."owner_id" = "person"."id"
    order by "pet"."name"
  ) as "agg"
) as "pets"
from "person"