Transactions on @effect/sql-drizzle/Pg

export const action = Effect.gen(function* () {
  const db = yield* PostgresDrizzle.PgDrizzle

  yield* db.delete(users).where(D.eq(users.id, "1"))
  yield* db.delete(users).where(D.eq(users.id, "2"))
  yield* db.delete(users).where(D.eq(users.id, "3"))

  yield* db.insert(users).values({ id: "1", name: "1" })
  yield* db.insert(users).values({ id: "2", name: "2" })
  yield* db.insert(users).values({ id: "3", name: "3" })

  return yield* db.select().from(users)
})