Re:Sqlfmt: an opinionated online SQL formatter
by MisterOctober on Thursday September 27, 2018 @11:48PM
(#18090895)
Yeah indeed -- though I'd prefer to write all lowercase for the sake of ease, I too stick to the 'uppercasing' norms mainly to help with ease of readability -- especially in shell-only environments where syntax highlighting isn't available [e.g., using psql]
But developers with good tooling to deal with more static views of the code aren't the only readers of SQL, and perhaps not the most common.
With my DBA hat on, trying to figure out what's going on reading through logs and such, I don't always have that kind of tooling available. In this context the casing can help as well.... and this may form some of my bias; my first professional experiences on the application side of the world were in very much DBA roles dealing with other people's applications running on my servers. Insofar as access tools preserve developer formatting, having good "color-blind" formats made reading complex queries easier.