Seeking Guidance on Implementing Database Transactions with Hono and Effect

export const EndpointRuntime = ManagedRuntime.make(
  Layer.mergeAll(
    PgDatabaseClient.Default,
    MySqlDatabaseClient.Default,
    ConfigLive.Default,
    ServiceOfferRepositoryLive.Default,
    LocaleRepositoryLive.Default,
    ServiceOfferServiceLive.Default,
  ),
);

aserviceOfferRoute.get(
  '/:id',
  getServiceOfferRoute,
  effectValidator('query', LocaleQuerySchema),
  async (ctx) => {
    const program = Effect.gen(function* (_) {
      const { locale } = ctx.req.valid('query');

      const serviceOfferService = yield* _(ServiceOfferServiceLive);
      return yield* serviceOfferService.findById(ctx.req.param('id'), locale);
    });

    const maybeServiceOffer = await EndpointRuntime.runPromiseExit(program);
    ... // rest of the code
  },
);