I'm just one data point, but this group I'm thinking of uses a LOT of CTEs. Perhaps too many - they seem to always have a bunch in their saved queries, personal

I'm just one data point, but this group I'm thinking of uses a LOT of CTEs. Perhaps too many - they seem to always have a bunch in their saved queries, personal notepad, etc and would probably benefit from being allowed to create views so that they'd have smaller queries with fewer WITH clauses. Seeing things like the above or spreadsheet power users really makes me think that "everyone should learn to code" education / literacy initiatives could be a very good idea if done properly.