K
Kysely•4w ago
mike

Custom joins (probably raw)

Hi, how can I type this in kysely? Thanks for any help
SELECT
a.code AS approval_code
FROM schema1."Forms" a
INNER JOIN schema1."FormTemplates" t
ON a."FormTemplateCode" = t.code
INNER JOIN LATERAL jsonb_each(a."additionalData") AS kv(key, value)
ON TRUE
INNER JOIN LATERAL jsonb_each(t."additionalDataFormats") AS tmpl(key, value)
ON tmpl.key = kv.key
SELECT
a.code AS approval_code
FROM schema1."Forms" a
INNER JOIN schema1."FormTemplates" t
ON a."FormTemplateCode" = t.code
INNER JOIN LATERAL jsonb_each(a."additionalData") AS kv(key, value)
ON TRUE
INNER JOIN LATERAL jsonb_each(t."additionalDataFormats") AS tmpl(key, value)
ON tmpl.key = kv.key
2 Replies
Igal
Igal•4w ago
Hey 👋 Can you share a minimal kyse.link?
mike
mikeOP•4w ago
Hi, something like this? https://kyse.link/Vlz6y

Did you find this page helpful?