Implementing Transactions in `drizzle-orm` with `Effect` Services

import { PgDrizzle } from "@effect/sql-drizzle/Pg";

const make = Effect.gen(function* () {
  const db = yield* PgDrizzle;
  yield* Effect.log("Profile effect initialized");

  const insert = (profile: Schema.Schema.Type<typeof InsertProfileSchema>) =>
    Effect.gen(function* () {
      //
    });

  return {
    insert,
  };
});

export class Profile extends Context.Tag("core/Profile")<Profile, Effect.Effect.Success<typeof make>>() {
  static Live = Layer.effect(Profile, make).pipe(Layer.provide(DatabaseLive));
}

await db.transaction(async (tx) => {
  await tx.update(accounts).set({ balance: sql`${accounts.balance} - 100.00` }).where(eq(users.name, 'Dan'));
  await tx.update(accounts).set({ balance: sql`${accounts.balance} + 100.00` }).where(eq(users.name, 'Andrew'));
});

const SqlLive = Pg.PgClient.layer({
  database: Config.succeed("db"),
});
const DrizzleLive = PgDrizzle.layer.pipe(Layer.provide(SqlLive));
export const DatabaseLive = Layer.mergeAll(SqlLive, DrizzleLive);