CTE / WITH + alias

functiondj · 2025-02-05T09:05:17.489Z

Playground: How can i generate the same SQL code (`left join "bar" as cte1`) without```js sql`${cte} as cte1` ```

Playground: https://drizzle.run/zb932yr9sv2w1nzn916wzvdt

How can i generate the same SQL code (

left join "bar" as cte1

left join "bar" as cte1

left join "bar" as cte1

left join "bar" as cte1)
without

sql`${cte} as cte1`

sql`${cte} as cte1`

sql`${cte} as cte1`

sql`${cte} as cte1`