DT
Drizzle Team•2y ago
tacomanator

CTE query of hierarchical data

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?
3 Replies
Dan
Dan•2y ago
tough luck - with recursive is not supported yet
tacomanator
tacomanatorOP•2y ago
thank you for letting me know. I'll stick with raw sql for this query for now 🙂
Dan
Dan•2y ago

Did you find this page helpful?