3 replies

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

$with

CTE query of hierarchical data

Similar Threads

CTE query of hierarchical data

Similar Threads

Similar Threads

Similar Threads