Recursive CTEs

Is it possible to use recursive CTEs with Drizzle ORM (

WITH RECURSIVE

WITH RECURSIVE

MySQL statement)?

Mario564•8/13/24, 1:19 AM

It's currently not possible in a type-safe way, but you can use the template literal to build your query. There's a PR on Github about adding to Drizzle

MMario564 It's currently not possible in a type-safe way, but you can use the `sql` templa...

rdobovicOP•8/13/24, 10:06 PM

Ok, thank you for your response, I will look into it.