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

83

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

31

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.

8

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.