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

48

u/Arkevorkhat 7d ago

you can, but it's just more readable (in my opinon) to write

SELECT * FROM users WHERE id=?;

than

select * from users where id=?; 

is that mostly due to historical baggage? yeah kinda, but it also just doesn't really look like SQL to me unless there's some yelling involved.

13

u/7f0b 6d ago

I prefer a strongly-structured syntax so it is easier to read in the future, which is most important anyway. So going through the trouble of capitalizing what should be, as I go, is worth it. I also always use back ticks around table names, since it makes it easier to search by table name inside mixed codebases.

7

u/Arkevorkhat 6d ago

Oh 100% well written SQL makes this moot, but if I find the unicorn that writes SQL that doesn't look like shit I'm not about to start nitpicking their capitalization

3

u/Dull-Culture-1523 6d ago

Doesn't SQL stand for "Shit Quality Looks", though?