import { Kysely } from 'kysely';
import { Json } from 'kysely-codegen';

// create a table with json values as it would be generated by codegen
type TestDB = {
    testTable: {
        testJsonColumn: Json;
    };
};
const db = {} as Kysely<TestDB>;
// query the json field
await db
    .selectFrom('testTable')
    .select(b => b.ref('testJsonColumn', '->$').key('someKey').as('myKey'))
    .execute();