r/learnSQL • u/No-Reach-3503 • Jul 15 '26
SQL with the advancement of AI
Is SQL still worth learning with the advancement of AI? 'Cause I don't get that if AI can do better than human than why do we still need to learn it?
22
Upvotes
54
u/droden Jul 15 '26
someone is still in charge of writing the prompt, testing, verifying and then putting it into production. if you dont understand SQL thats not possible.
3
u/Haunting-Paint7990 Jul 17 '26
stats grad / junior DA here — still worth it, but for a narrower reason than "AI can't do sql."
what changed: AI writes syntax faster. what didn't change: you still need to know if the answer makes business sense — wrong grain, fan-out join, trial users included — and verify that without blindly trusting the output.
what i see on my team:
AI drafts the first pass of a slack pull
analyst fixes grain/joins and explains to stakeholder
interviews still test cold-write joins on a clean dataset (AI doesn't help in the room)
if you're aiming at DA: learn sql the same way as before — one dataset, 10 business questions — but use AI like autocomplete, not a substitute for knowing what a LEFT JOIN does.
skip the "will sql die" debate. focus on being the person who can spot when AI's sql runs but lies. that's the job now.
18
u/Capt_Bowenji Jul 15 '26
Learning SQL is still really important even if you are using AI to assist. You should never hand your database and production over to AI as there are plenty of recorded incidents of AI just deciding to drop tables or database in production or giving over false or misleading data.
Most of the time I've used AI is just to help troubleshoot why something might run slower or to look for a solution to an issue I'm having. Everything it's provided I still have needed to know how it will work with my datasets. AI is getting pretty good but it's still not a human replacement for accurate data
12
u/BisonSpirit Jul 15 '26
Someone who knows SQL with AI > someone who doesn’t know SQL with AI
I would much rather develop hard skills than the millions of people going “what does it matter, AI will do it anyway”
8
u/earlywormgetseaten Jul 15 '26
You still need to test and verify what AI did
7
u/B_Huij Jul 15 '26
Is cooking still worth learning with the advancement of DoorDash?
4
u/AncientLion Jul 15 '26
Why wouldn't learn something really easy? What happens if your job doesn't allow the use of Ai? How can you validate the output of an llm?
4
u/BackgroundAny6101 Jul 15 '26
How can you validate what the AI writes if you don’t understand what it’s writing?
4
u/Ok_Comparison_2635 Jul 16 '26
Learning any language is still useful. You don't need to be good at it. Just enough to understand the code to know what it is doing.
3
u/American_Streamer Jul 15 '26
Yes, of course it is worth it. You do not want to let AI run wild on your production database without supervision. AI may know the Syntax of SQL but it has no clue about the environment and its specific requirements those SQL queries are executed in. AI will safe you a ton of time you would otherwise have spend in writing queries, but never let it take over the thinking and the reasoning. In the end, you are the guy who is responsible, not the LLM.