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?

tough luck - with recursive is not supported yet

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