My experience has been there are definitely people who become very proficient with sql while not knowing any other programming but they generally hit a ceiling. For most people they can do joins and some basic nesting but they start getting out of their elements if you mention window functions, ctes etc
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.
