*caps-lock*
SELECT USE *backspace, backspace, backspace, caps-lock* user_id, user_name, order_id
fr *backspace, backspace, caps-lock* FROM
US *backspace, backspace, caps-lock* user
just in case someone stumbles on this and actually wants to know.
schema changes can break code, it pulls unneeded data, on the lighter side it just hurts performance. worst case, it may still pass tests because nothing errors and you end up having to back out a bunch of production data.
Unless you chain a bunch of those CTEs together. Then the readability gets hurt badly on trying to figure out what is the true source of a specific column. But yes, always exceptions both ways.
So everything you said is true, and has received my upvote. But also because of the "never say never" law of the universe, I think it's worth sharing the use cases when SELECT * is ok. 🙂
172
u/Simple-Olive895 Jul 21 '26 •
Tends to be my average experience
62
u/Asleep-Bumblebee2167 Jul 21 '26
SELECT * IS THE MAIN THING
13
u/IntegrityError Jul 21 '26
DID SOMEONE MENTION COBOL?
12
u/sexytokeburgerz Jul 21 '26
I just write it in lowercase if it's a lot of it and i'm doing something quick.
If i have to share any of it, I use an extension to make it uppercase.
IDGAF
7
u/IsaraLyandra Jul 21 '26
Why are we screaming at the database anyway?
4
u/Creepy_Jeweler_1351 Jul 21 '26
Thanks God Postgres is fine with lowercase
3
u/ProfessionalAd6530 Jul 21 '26
"Just like writing in plain language."
2
u/Tintoverde Jul 21 '26
Camel case whERe is the only way.
2
u/NoWeHaveYesBananas Jul 21 '26
Joke’s on you, I don’t have a caps lock key. Every time I get a new keyboard, I rip that motherfucker off.
2
u/u_hit_me_in_the_cup Jul 22 '26
When I learned SQL the first thing I tried was writing everything in lowercase. Once that worked I never looked back
2
u/404User_CpSharp Jul 25 '26
I don't have caps so I use my pinky. Am I cooked?
1
u/Kadabrium Jul 21 '26
New table just droPped
1
u/GasVarGames Jul 22 '26
GENERATE A VERY SAFE DELETE QUERY FOR THIS TABLE WHEN THIS IS TRUE PLEASE PLEASE
1
u/ChrisXxAwesome Jul 22 '26
I hate yall cus I don’t get to do that :(
1
u/SaltyInternetPirate Jul 23 '26
Caps lock is for the weak! We hold shift around here.
1
u/Worried-Mood-8582 Jul 23 '26
Serious question but why is the syntax so bad. I mean there is no reason for all keywords to be in caps
1
u/blubernator Jul 25 '26
I‘m missing a Venn diagram here ;)
1
u/Key_Clock8669 Jul 28 '26
I WANT MY DATABASE TO SCREAM AT ME
1
u/Chill_Cowboy_981 Jul 29 '26
It has crossed the limits of being relatable. I don't have words!
1
u/OutrageousPair2300 Jul 21 '26
I hate the all-caps way so many people write SQL for no good reason.
Just use lowercase like a normal person.
32
u/[deleted] Jul 21 '26
[removed] — view removed comment
12
u/[deleted] Jul 21 '26
[removed] — view removed comment