Recursive CTEs

Is it possible to use recursive CTEs with Drizzle ORM (

WITH RECURSIVE

WITH RECURSIVE

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

sql

sql

template literal to build your query. There's a PR on Github about adding with recursivewith recursive to Drizzle

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

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