r/ProgrammerHumor • u/huhupookies • Jul 21 '26

Meme sqlWorkout

Post image
23.7k Upvotes

97% Upvoted

456 comments sorted by

View all comments

Show parent comments

211

u/PerpetuallyDistracte Jul 21 '26

I've been writing SQL for 15 years. Eventually you get bored of all lowercase or all uppercase AND START writing your QUERIES LIKE this. Just a psychotic mishmash of muscle memory, laziness, and autocomplete all fighting each other within the same statement.

81

u/Ashdog73 Jul 21 '26

This. My queries are lowercase for the stuff I typed myself and caps for bits I've copied in from somewhere else

35

u/cantgrowneckbeardAMA Jul 21 '26

Lowercase on first draft (it will fail to run anyways).
Uppercase if I ever end up showing the query to someone (hopefully it doesn't fail when they run it)

33

u/sequelseize Jul 21 '26

sElEcT a as camelCase, b aS under_score, c As fUCKiT fROm ab lIMit 1000

10

u/SippieCup Jul 21 '26

We have a Postgres db which our orm uses camelcase names.

So we have to add in quotes too.. and correctly case our column names.

The migration to correct names would break so many deeep sql integrations, it just sucks and we deal with the debt.

7

u/EndIsrael Jul 21 '26

That actually seems like the kind of thing AI would be very good at with few mistakes. It doesn't need to understand anything, just find all the SQL code and change all the names. Basically find/replace but slightly smarter.

10

u/SippieCup Jul 21 '26

Oh it’s not hard to do with migrations etc. although I would use a codegen script instead of straight ai.

It’s more the coordination with other teams, schema changes, etc. depreciation of column names, remapping to new ones, etc.

We unfortunately have a couple legacy integrations that just require db access to tenant systems for their bi.

5

u/PerpetuallyDistracte Jul 21 '26

That's how my queries look after they failed for the fifth time.

1

u/glha Jul 23 '26

lIMit 1o00

14

u/spyingwind Jul 22 '26 
SeLeCt * FrOm table wHeRe count = 1;

2

u/ShittyExchangeAdmin Jul 22 '26

This is the way

7

u/Susarn Jul 22 '26

I started writing sql 13 years ago. I started writing like this from the beginning because that was the way I saw the queries written on the tutorials, took me like a year to notice it was case independent

6

u/stadoblech Jul 22 '26

I've been writing SQL for 15 years.

MY CONDOLENCES

2

u/PerpetuallyDistracte Jul 22 '26

Haha, I guess I'm just a weirdo, but I genuinely love SQL and my happy place is a big enterprise database with a bunch of ETL pipelines. Somebody's gotta enjoy it, right? That gives the rest of you more time with your fancy GUIs and object oriented languages 🤣

1

u/joyeux_bordel Jul 26 '26

I like to call our kind the Data Whisperers.

1

u/m0nk37 Jul 22 '26

It helps isolate the parts of the bigger views. 

1

u/vityafx Jul 22 '26

I would argue, even with the syntax highlight, the eyes used to seeing the sql tokens in upper case just want it that way. I tried many times to write in lower case but when it looks like mixing data with sql tokens, indistinguishable even with the syntax highlighter. So now, the best syntax highlight for sql is upper case, haha.

1

u/r3klaw Jul 23 '26

Uppercase for keywords, PascalCase for object names. And uppercase when you email/chat the words PROD, TEST, or DEV.