refactor SELECT into CTE
The way I work when creating complicated scripts is creating all the SELECT statements and then convert them to CTEs of my final query.
It would be nice if you could convert SELECT into CTE
7
votes
Ilan Sernov
shared this idea
-
Traber
commented
I do the same thing and it would be very helpful to have this feature to extract the select query into a CTE with alias and update any predicates and joins