CTE query of hierarchical data

Ttacomanator4/18/2023
I'd like to drizzle-ize this query:
WITH 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
Child(n) AS (
VALUES('...id')
UNION
SELECT id FROM User, Child
WHERE User.parentId=Child.n
)
SELECT * FROM Application
WHERE Application.ownerUserId IN Child;
But having trouble finding relevant docs. Is it possible without raw sql using $with?
Bbloberenober4/19/2023
tough luck - with recursive is not supported yet
Ttacomanator4/19/2023
thank you for letting me know. I'll stick with raw sql for this query for now 🙂

Looking for more? Join the community!