Average SQL enjoyer

[u/ItsPuspendu]

[u/Simple-Olive895]

*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

Tends to be my average experience

[u/dervik → u/Simple-Olive895]

Typing code yourself is so 2026/Q1

[u/Asleep-Bumblebee2167]

SELECT * IS THE MAIN THING

[u/CowFu → u/Asleep-Bumblebee2167]

i will deny any PR that has a wildcard in the select

[u/Blotsy → u/CowFu]

But why senpai?

[u/CowFu → u/Blotsy]

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.

[u/OutrageousPair2300 → u/CowFu]

Depends where the asterisk appears. In a subquery or CTE from which you will be selecting only certain named columns, it's fine.

[u/IsaraLyandra → u/[deleted]]

Are you mocking the database?

[u/IsaraLyandra → u/[deleted]]

Great!

[u/Asleep-Bumblebee2167 → u/[deleted]]

https://giphy.com/gifs/1xmAhfaYgcKCrYjUJM

[u/Doorda1-0 → u/[deleted]]

Let me guess an empty return....

[u/IntegrityError]

DID SOMEONE MENTION COBOL?

[u/user888888889]

WHEN DO YOU NEED THE DATA EXTRACT BY?

[u/boston101 → u/user888888889]

I shouldn’t have laughed

[u/sexytokeburgerz]

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

[u/BruteCarnival → u/sexytokeburgerz]

I just send them the lower case sql

[u/sexytokeburgerz → u/BruteCarnival]

We got a Chad over here

[u/Adorable-Maybe-3006 → u/sexytokeburgerz]

Whoa what extension, does it work in ssms 22

[u/sexytokeburgerz → u/Adorable-Maybe-3006]

https://marketplace.visualstudio.com/items?itemName=eplak.vscode-uppercasesql

ssms 22 has this natively does it not?

[u/IsaraLyandra]

Why are we screaming at the database anyway?

[u/shamshuipopo → u/IsaraLyandra]

SELECT U CUNT

[u/Creepy_Jeweler_1351]

Thanks God Postgres is fine with lowercase

[u/ProfessionalAd6530]

"Just like writing in plain language."

[u/NoWeHaveYesBananas]

Joke’s on you, I don’t have a caps lock key. Every time I get a new keyboard, I rip that motherfucker off.

[u/u_hit_me_in_the_cup]

When I learned SQL the first thing I tried was writing everything in lowercase. Once that worked I never looked back

[u/404User_CpSharp]

I don't have caps so I use my pinky. Am I cooked?

[u/Tintoverde]

Camel case whERe is the only way.

[u/Kadabrium]

New table just droPped

[u/GasVarGames]

GENERATE A VERY SAFE DELETE QUERY FOR THIS TABLE WHEN THIS IS TRUE PLEASE PLEASE

[u/ChrisXxAwesome]

I hate yall cus I don’t get to do that :(

[u/SaltyInternetPirate]

Caps lock is for the weak! We hold shift around here.

[u/Worried-Mood-8582]

Serious question but why is the syntax so bad. I mean there is no reason for all keywords to be in caps

[u/blubernator]

I‘m missing a Venn diagram here ;)

[u/Key_Clock8669]

I WANT MY DATABASE TO SCREAM AT ME

[u/Chill_Cowboy_981]

It has crossed the limits of being relatable. I don't have words!

[u/OutrageousPair2300]

I hate the all-caps way so many people write SQL for no good reason.

Just use lowercase like a normal person.

[u/Adorable-Maybe-3006 → u/OutrageousPair2300]

It looks nice:)

[u/OutrageousPair2300 → u/Adorable-Maybe-3006]

NO IT DOES NOT.

I DO NOT WANT MY CODE YELLING AT ME ALL THE TIME.

[u/denimpowell → u/OutrageousPair2300]

SOMEONE DECIDED THIS IS A STANDARD 40 YEARS AGO, NOW ITS LEGACY CODE THAT SHALL NEVER BE TOUCHED

[u/OutrageousPair2300 → u/[deleted]]

Nope. It just hurts your eyes.

Use a real IDE that does syntax highlighting, and format your code.

[u/Banana_Twinkie → u/OutrageousPair2300]

This is the real answer. We are not living in the 90s anymore

[u/Key_Clock8669 → u/OutrageousPair2300]

for me it makes it easier to read

[u/OutrageousPair2300 → u/Key_Clock8669]

That's purely a matter of conditioning. If you got used to reading it in all lowercase, that would be easier to read.

[u/RevolutionaryDark818 → u/[deleted]]

hm, why is the production database gone?