DT
Drizzle Team•15mo 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
bloberenober
bloberenober•15mo ago
tough luck - with recursive is not supported yet
tacomanator
tacomanator•15mo ago
thank you for letting me know. I'll stick with raw sql for this query for now 🙂
bloberenober
bloberenober•15mo ago
Want results from more Discord servers?
Add your server
More Posts
createInsertSchema wrong type (drizzle-zod 0.3.1, sqlite))After upgrading to 0.3.1, all of the fields changed to ZodTypeAnyHow do I get the values of an insert inside a transaction?I have this transaction where I create a project and add variables and a history of those variables.Raw sql`` quoting issueHi, I doing a work around until Drizzle supports generated columns. I have a manual script that addsNuxt3 type errorHello, is there somebody who used Drizzle in Nuxt3 project? I have problem with inheriting types froSyntax error mysql migration using composite primary key```sql --> statement-breakpoint CREATE TABLE `member_to_address` ( `member_id` varchar(32) NOT Nwhen using planetscale, using the `.$with()` and `.with()` clauses causes errorIs it not possible to use `$with()` and `with()` with planetscale? it gives the following error: `DaZod prototype mismatchEven though the Zod object constructor name created by Drizzle is ZodObject, it is not an instanceofunrecognized_keysGetting the following error when running generate:pg ``` ZodError: [ { "code": "unrecognized_k