Transactions

const result = await db.transaction().execute(async (trx) => {
  // First, create our superhero
  const batman = await trx
    .insertInto("person")
    .values({
      first_name: "Bruce",
      last_name: "Wayne",
      age: 35,
    })
    .returning("id")
    .executeTakeFirstOrThrow();

  // Then add his trusty sidekick
  const robin = await trx
    .insertInto("pet")
    .values({
      owner_id: batman.id,
      name: "Robin",
      species: "human",
      is_favorite: true, // Don't tell the other sidekicks
    })
    .returningAll()
    .executeTakeFirst();

  // Finally add his noble steed
  const batmobile = await trx
    .insertInto("pet")
    .values({
      owner_id: batman.id,
      name: "Batmobile",
      species: "car",
      is_favorite: true, // He loves it equally
    })
    .returningAll()
    .executeTakeFirst();

  return { robin, batmobile };
});