What is the best way to join with JSONB arrays with Drizzle?
Hi guys,
I'm trying to migrate the following query to Drizzle:
SELECT "mutzar"."misparzihuylakoach",
"mutzar"."sugmutzar",
"mutzar"."shemyatzran",
"heshbonopolisas" ->> 'MISPAR_POLISA_O_HESHBON'
FROM "mutzar"
LEFT JOIN Jsonb_array_elements("data" -> 'HeshbonotOPolisot' ->
'HeshbonOPolisa'
) AS
"heshbonOPolisas"
ON TRUE
WHERE "mutzar"."misparzihuylakoach" = $1 -- params: ["123123123"]
I've successfully migrated it to:
const result = await db
.select({
misparZihuyLakoach: mutzar.misparZihuyLakoach,
sugMutzar: mutzar.sugMutzar,
shemYatzran: mutzar.shemYatzran,
misparPolisaOHeshbon: sql
})
.from(mutzar)
.leftJoin(
sql
eq(sql
)
.where(eq(mutzar.misparZihuyLakoach, '123123123'));
I've tried following the docs and using const heshbonOPolisas = alias(sqljsonb_array_elements("data"->'HeshbonotOPolisot'->'HeshbonOPolisa'), "heshbonOPolisa") but got a type error
What is the best way to join with JSONB arrays with Drizzle?
I'm trying to migrate the following query to Drizzle:
SELECT "mutzar"."misparzihuylakoach",
"mutzar"."sugmutzar",
"mutzar"."shemyatzran",
"heshbonopolisas" ->> 'MISPAR_POLISA_O_HESHBON'
FROM "mutzar"
LEFT JOIN Jsonb_array_elements("data" -> 'HeshbonotOPolisot' ->
'HeshbonOPolisa'
) AS
"heshbonOPolisas"
ON TRUE
WHERE "mutzar"."misparzihuylakoach" = $1 -- params: ["123123123"]
I've successfully migrated it to:
const result = await db
.select({
misparZihuyLakoach: mutzar.misparZihuyLakoach,
sugMutzar: mutzar.sugMutzar,
shemYatzran: mutzar.shemYatzran,
misparPolisaOHeshbon: sql
"heshbonOPolisas" ->> 'MISPAR_POLISA_O_HESHBON'})
.from(mutzar)
.leftJoin(
sql
jsonb_array_elements("data"->'HeshbonotOPolisot'->'HeshbonOPolisa') as "heshbonOPolisas"eq(sql
TRUETRUE)
.where(eq(mutzar.misparZihuyLakoach, '123123123'));
I've tried following the docs and using const heshbonOPolisas = alias(sqljsonb_array_elements("data"->'HeshbonotOPolisot'->'HeshbonOPolisa'), "heshbonOPolisa") but got a type error
What is the best way to join with JSONB arrays with Drizzle?
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,959Members
Resources
Similar Threads
Was this page helpful?
