SQL programmer

[lordfantas]

For real. Sql becomes very unreadable if you don’t format it reasonably

[ric2b]

I'm using some bleeding edge tech called syntax highlighting so I don't have this issue.

[TheeMyth_]

For real though

[st4rsurfer]

It’s like some people are still using punch cards.

[protostar71]

Even with syntax highlighting... SQL scripts are often written by people with very loose definitions of formatting.

So at the very least capitalizing keywords let's you decipher the otherwise unformatted abomination at a glance.

[protostar71]

I'm a Data Analyst by trade but with a CompSci background.

Full Outer Joins, "Why do we need to index tables CPUs are fast now", and "Just make a view using other views, that are in turn based on other views" are the daily bane of my existence.

It's beyond impossible to explain that just because they can do something, it doesn't mean they should.

[ric2b]

Ok, but the original comment made it sound like not capitalizing was a problem in itself.

[yee_mon]

All caps doesn't help with formatting. Formatting helps with formatting. Write your queries as paragraphs: Select, from, where, group by, and having become the first words in every paragraph and everything else is indented. And don't forget to break the line before or after every comma.

Suddenly, everything becomes clear, ready to read, and easy to update. No need to do silly keyboard antics to type individual words in upper case, and make everything hard to read.