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•2y ago

tough luck - with recursive is not supported yet

tacomanatorOP•2y ago

thank you for letting me know. I'll stick with raw sql for this query for now 🙂

Dan•2y ago

https://github.com/drizzle-team/drizzle-orm/issues/209

GitHub

Support WITH RECURSIVE · Issue #209 · drizzle-team/drizzle-orm

Gaming

Programming

CTE query of hierarchical data