function knexToKyselyTransaction(knexTransaction: KnexTransaction): Kysely<DB> {
   return new Kysely<DB>({
    dialect: new KyselyKnexDialect({ knex: knexTransaction, kyselySubDialect  }),
  });
}

function someLegacyFunction(knexTx: KnexTransaction) {
    const testEmail1 = 'knex-test@example.com';
    const testEmail2 = 'kysely-test@example.com';
    const testEmail3 = 'knex-update@example.com';
    try {
        const kyselyTx = knexToKyselyTransaction(knexTx);

        // Perform operations with Knex
        await knexTx('users').insert({
          email: testEmail1,
          password: 'password1',
          name: 'Knex User',
        });

        // Perform operations with Kysely
        await kyselyTx
          .insertInto('users')
          .values({
            email: testEmail2,
            password: 'password2',
            name: 'Kysely User',
          })
          .execute();

        // Perform another Knex operation
        await knexTx('users')
          .insert({
            email: testEmail3,
            password: 'password3',
            name: 'Knex Update User',
          })
          .returning('id');

        // Update with Kysely
        await kyselyTx
          .updateTable('users')
          .set({ name: 'Updated Knex User' })
          .where('email', '=', testEmail3)
          .execute();

        // Verify data exists within both Knex and Kysely transactions (before commit)
        const usersInKnexTransaction = await knexTx('users').whereIn('email', [testEmail1, testEmail2, testEmail3]);
        const usersInKyselyTransaction = await kyselyTx.selectFrom('users').selectAll().where('email', 'in', [testEmail1, testEmail2, testEmail3]).execute();

        expect(usersInKnexTransaction).to.have.length(3);
        expect(usersInKyselyTransaction).to.have.length(3);

        throw new Error('Intentional error to test rollback');
    } catch (error) {
      expect(error).to.be.instanceOf(Error);
      expect((error as Error).message).to.equal('Intentional error to test rollback');
    }

  const usersAfterRollback = await kysely.selectFrom('users').selectAll().where('email', 'in', [testEmail1, testEmail2, testEmail3]).execute();
  expect(usersAfterRollback).to.have.length(0, 'All changes should have been rolled back');
}