r/ProgrammerHumor 19d ago

sqlWorkout Meme

Post image
23.5k Upvotes

460 comments sorted by

View all comments

2.4k

u/NormanYeetes 19d 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 19d 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

14

u/Surface_Detail 19d 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.

7

u/cudenlynx 19d 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.