How can I join 2 tables where 1 side is a JSON property in a JSON column?
I am trying this:
I am getting a type issue:
I am getting a type issue:
db.selectFrom('my_table')
.selectAll(['my_table'])
.innerJoin(
'table_2',
'table_2.id',
sql`my_table.metadata->>'id'`,
)
.select(['table_2.name'])Argument of type 'RawBuilder<unknown>' is not assignable to parameter of type 'AnyJoinColumn<KyselyDB, "my_table", "table_2"> | AnyJoinColumnWithTable<KyselyDB, "my_table", "table_2">const rows = await db
.selectFrom("my_table")
.innerJoin("table_2", (jb) =>
jb.on("table_2.id", "=", (eb) =>
eb.ref("my_table.metadata", "->>").key("id"),
),
)
.execute();