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;


But having trouble finding relevant docs. Is it possible without raw sql using $with?
Was this page helpful?