3 ms·
side note: I asked chatgpt to rewrite this query to use subqueries and it did a reasonable job. next step: include cte-to-subquery translation step as a part o
by baq 4y ago
side note: I asked chatgpt to rewrite this query to use subqueries and it did a reasonable job.
next step: include cte-to-subquery translation step as a part of your build pipeline. never needed tools like that but i guess they must exist since it's been such a common issue. using gpt for this is like nuking a mosquito from orbit.
- srcreigh 4y agoAS NOT MATERIALIZED is equivalent to using sub queries