Issue with Session Persistence in SQL-Kysely Transactions

set app.current_tenant_id='abc';
select * from messages;

  db.withTransaction(
      Effect.gen(function* () {
          yield* Effect.tryPromise({
              try: () => db.executeQuery(CompiledQuery.raw('set app.current_tenant_id="abc"')),
              catch: (e) =>
                  new SqlError.SqlError({
                      cause: e,
                      message: 'Error setting current_tenant_id',
                  }),
          })
          return yield* db.selectFrom('messages').selectAll()
      }),
  )