CTE query of hierarchical data
I'd like to drizzle-ize this query:
But having trouble finding relevant docs. Is it possible without raw sql using
But having trouble finding relevant docs. Is it possible without raw sql using
$with?$withWITH RECURSIVE
Child(n) AS (
VALUES('...id')
UNION
SELECT id FROM User, Child
WHERE User.parentId=Child.n
)
SELECT * FROM Application
WHERE Application.ownerUserId IN Child;with recursive is not supported yetwith recursive