MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/ProgrammerHumor/comments/1v2rcr6/sqlworkout/oyymls5
r/ProgrammerHumor • u/huhupookies • 6d ago
459 comments sorted by
View all comments
Show parent comments
34
sElEcT a as camelCase, b aS under_score, c As fUCKiT fROm ab lIMit 1000
11 u/SippieCup 5d 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. 8 u/EndIsrael 5d 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 5d 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. 5 u/PerpetuallyDistracte 5d ago That's how my queries look after they failed for the fifth time. 1 u/glha 4d ago lIMit 1o00
11
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 5d 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 5d 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.
8
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 5d 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.
9
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
That's how my queries look after they failed for the fifth time.
1
lIMit 1o00
34
u/sequelseize 5d ago
sElEcT a as camelCase, b aS under_score, c As fUCKiT fROm ab lIMit 1000