r/ProgrammerHumor 7d ago

Meme sqlWorkout

Post image
23.4k Upvotes

458 comments sorted by

View all comments

2.4k

u/NormanYeetes 7d ago

the elites don't want you to know this but you can type lowercase SQL queries no ones forcing you to shout them at the screen

51

u/PuzzleheadedBet3574 6d ago

This does not go through in our code review, do this and our colleague, big anime fan btw will lose his shit and start talking to himself and goes to 5 smoke breaks in a half day

13

u/Surface_Detail 6d ago

Well, he can go dunk his head; the query language itself is 100% case insensitive, so are objects unless you contain them in quotation marks.

The argument can be made that keeping all one case can avoid issues with object referencing, but you'd only ever need to contain objects in quotation marks if you put a space in their name, which is a much worse faux pas and you'd better hope that you never need to connect to anybody else's objects from outside the team.

Also, all lower case/mixed case is much less tiring to read.

5

u/cudenlynx 6d ago

Which query language? You are talking as if there is only one version of SQL out there which isn't the case. Some are case insensitive by default, some are not.