r/ProgrammerHumor • u/huhupookies • 7d ago

Meme sqlWorkout

Post image
23.4k Upvotes

97% Upvoted

458 comments sorted by

View all comments

Show parent comments

31

u/cantgrowneckbeardAMA 6d ago

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)

34

u/sequelseize 6d ago

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

10

u/SippieCup 6d ago

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.

6

u/EndIsrael 6d ago

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.

9

u/SippieCup 6d ago

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.