DO NOT USE LOWERCASE IN SQL, STUPID.

Probably a little OCD on my part, but when colleagues write SQL keywords in lowercase

My Database Teacher writes the SQL commands in lowercase. It really grinds my gears.

Sent a fully constructed sql statement to someone expecting at least 4 rows however received reply "the result is empty" with a screenshot of empty result set from sql-developer. I kept cross-checking the where clause thinking I mixed something up.

After a few back and forth emails suddenly noticed the screenshot I received initially and I see all of the strings in where clause are lowercase. I reference my version and it is correct. When I asked her why are the strings in sql lowercase and that if she has tried the exact sql I sent in the email, the response "I didn't think it mattered what case the sql was in".

I am lost for words. The worse part is, this is someone who is supposed to go on site as part of their job and help clients setup, explain and train how the software works. This includes explaining how software intreacts with database tables 🤐

Helped a colleague today with finding the reason why everything was lowercase after a release. Turns out another colleague made a SQL upgrade script two months ago the did REPLACE(lower(value)... Found it in 10 minutes, saved a lot of time on debugging and still got scolded for working to long on another ticket...

I'm doing a code review and, it's not unheard of to have lowercase SQL im our codebase even though most of it is uppercase. For this reason I decided to let the lowercase SQL slide even though it makes me cringe so much... That is, until I came to one procedure that was uppercase and in this revision it is lowercase :O I want to die a gruesome way which would be very nice compared to this :O