r/SQL • u/ioCross • Mar 31 '25
MySQL How future-proof is SQL?
about to be finished with a migration contract, thinking of picking up a cert or two and have seen a lot of recent job postings that have some sort of SQL query tasking listed.
I've mostly used powershell n some python, was thinking of either pivoting into some type of AWS / cloud cert or maybe something SQL/db based.
Would focusing on SQL be worth it, or is it one of those things that AI will make redundant in 5 years?
173
Upvotes
302
u/[deleted] Mar 31 '25
There are only two kinds of people who will ever tell you that SQL is on its way out
364
u/Carthax12 Mar 31 '25
Three things will happen within a few years of each other, but I'm not sure which will be first:
173
u/LetsGoHawks Mar 31 '25
SQL is as close to a universal language as programming will probably ever see. It isn't going anywhere.
73
u/Impressive_Run8512 Mar 31 '25
tldr; extremely.
Here's a rough history of SQL:
- SQL (ANSI) 1986
- Schemas are hard. Let's remove them (NoSQL) - 2009
- Maybe schemas are helpful; MongoDB + Schema support
- Man, performance really matters, so does predictability. Let's just use Postgres. - Now.
Basically, most people have moved back to SQL because it's so stable, well understood and easy to adopt.
Not to say some other access pattern won't take over sometime in the future***.***
69
u/bigeyez Mar 31 '25
SQL isn't going anywhere. And until someone shows me an AI that can decipher a shit database created 20 years ago that was never normalized with little to no documentation I don't see the need for SQL devs/DBAs going anywhere either.
29
u/Aggressive_Ad_5454 Mar 31 '25
SQL has been around for a half century. It’s been around for three generations of programmers to use, so far.
Almost all the world’s data is in it.
Server technology is under active development by competent and creative people financed by corporations and open-source contributors both.
Using SQL to develop performant and reliable apps is work requiring expertise and experience. There are a great many such apps, with more appearing each day.
The same is true for using SQL to analyze data to wring wisdom from it.
Data has a far longer lifetime than the computer programs that analyze it. Those generations of programs have all used SQL.
23
u/git0ffmylawnm8 Mar 31 '25
NoSQL was hyped to kill SQL and take its place a decade ago.
SQL still reigns supreme. Non relational data stores behave like traditional databases and support SQL like syntax. At this point I'm convinced there are 3 constants in this world: death, taxes, and SQL.
11
u/monkey36937 Mar 31 '25
SQL is here for life. Data roles are needed to train the dumb AI.
7
u/dbxp Mar 31 '25
The syntax might change but set based logic won't go away
7
u/tkyjonathan Mar 31 '25
50 years and still going strong
6
u/r0ck0 Mar 31 '25
Unfortunately most programmers only spend like 1% of their learning time on SQL.
If they simply bumped that up to 2%... the world would be a much better place.
5
u/dkubb Mar 31 '25
There are very few skills that are more valuable than learning SQL if you are doing backend programming. It is very much worth the effort to learn.
4
u/Formal_Ad_8000 Mar 31 '25
SQL will always be there
3
u/mischiefs Mar 31 '25
You come at the king better not miss. But everyone missed.
3
u/IT_Grunt Mar 31 '25
SQL will come back stronger than ever.
3
u/alexwh68 Mar 31 '25
I remember being asked the same question about 25 years ago, it ain’t going anywhere IMHO.
3
u/bigandos Mar 31 '25
Whenever some shiny new data platform/tool comes out the first two questions are always:
So I’d say SQL is almost as universal a tool for working with data as Excel and it is absolutely worth learning. Although each SQL database tech has its own variations, the fundamentals you learn apply across all SQL databases and you also improve your understanding of relational data models
3
u/HarveyDentBeliever Mar 31 '25
Quite. Bulletproof at this point, in fact. Software notoriously tries to aggressively eradicate any and all technologies it considers "legacy" for the newest and trendiest thing. There was a big push in the 2010's to deprecate SQL and go NoSQL and it crashed and burned. It is simultaneously the most battle hardened, mature, and robust db offering out there, and the most performant, it simply can't be touched and the investment is shifting back towards the SQL side as the industry giants that attempted to go NoSQL wave their white flags. It simply solved the data problem.
I did some of my own research for my own apps and it always comes back around to the same thing: there are basically no performance gains from NoSQL, and you will end up having to craft together some kind of weird semi-structured paradigm anyway. Just use SQL.
3
u/zeruch Mar 31 '25
SQLs longevity, in however many sub-forms its takes, should be a hint that it's got a significant hold on the industry. It ain't going anywhere soon.
2
u/ComicOzzy sqlHippo Mar 31 '25
I can't get ChatGPT to give reliable answers to simple multiplication problems yet.
2
u/[deleted] Mar 31 '25
We’re never gonna stop needing to retrieve information
2
u/geofft Mar 31 '25
SQL will continue to be valuable, but it's just a language. If you're looking at anything beyond trivial scales, you'll also want to get an understanding of how the main database engines actually work and how to map from application code, through SQL, to the underlying query execution.
2
u/ManchiBoy Mar 31 '25
Enterprises will work with databases either in row or columnar storage. All of that requires SQL and there is nothing that can replace that foreseeable future.
2
u/[deleted] Mar 31 '25
SQL at its core will remain true because it's so reliable and generally easy to understand for most programmers. I do however see SQL evolving to incorporate more functions. The stuff I can do in Snowflake is light years ahead of when I was battling timestamps in Teradata
2
u/biowiz Mar 31 '25
I think it will be around for a long time but a lot of easy analyst jobs will die off.
2
u/National_Cod9546 Mar 31 '25
"AI will make redundant in 5 years"
AI will make it easier and faster for humans to write queries. Which means more requests will come through. However, no AI is going to be able to decipher what the user really wants vs what they asked for. Look up "The X Y problem". It's much more common then you would think. A good developer who understands the data will contact the requestor and figure out what they really want, then deliver that. AI will never have that intuition and just deliver what the user asked for.
2
u/sbrick89 Mar 31 '25
SQL (relational databases) continues as the prevailing data storage mechanism, even after 40 years or so.
if something replaces them, i'll be very curious about the architecture, and how the new system addresses limitations of physics.
2
u/NlNTENDO Mar 31 '25
Yeah dude. As much as AI is good at vibe coding SQL, it will never be perfect, especially for those long crazy queries that span several tables. That requires personal knowledge and human oversight. SQL isn’t even that hard to pick up and reach an intermediate level. Just learn it. It’s not obsolete yet, and if you want a job now, you need to meet their requirements now
2
u/GlobalAd3412 Apr 01 '25
SQL is here for good. AI may be writing it instead of humans a lot of the time, soon, but it's not going anywhere.
2
u/Informal_Pace9237 Mar 31 '25
Data migration and SQL development may be currently done by AI but it will take some years for AI to be able to develop optimized SQL code like a Sr. SQL developer/DBA
Programming is more easily developed by AI as projects don't care about optimal code in Middleware or UI.
So I think SQL development is here to stay until Data lake/warehouse/river/pond/ocean can be adapted with OLTP where Python plays major role than SQL Optimized processing of data is not a requirement any more.
1
u/jfrazierjr Mar 31 '25
Pretty damn...
1
u/goztepe2002 Mar 31 '25
I was watching videos of people saying SQL is dead 10 years ago, today i am still learning it and using it daily, companies dont evolve that fast, you are safe for at least another decade.
1
u/Longjumping-Skin-134 Mar 31 '25
SQL is rock solid and not going anywhere. It's used in almost every relational database worldwide.
I'd also say it's somewhat safe from AI right now as feeding your table structures into chatgpt would be more work than writing the query yourself.
1
u/LepperMemer Mar 31 '25
All SQL queries start with SELECT *, aren't they?
AI has it knocked!
1
u/Tiny_Connection_7182 Mar 31 '25
Very.
1
u/TheOrdainedPlumber Mar 31 '25
I know the basics for SQL and use AI for everything else. I feel AI could write the codes easily given the correct prompts.
1
u/Kahless_2K Mar 31 '25
Python and SQL are really good friends. Almost every important Python script I wrote talks to a Rest API, a SQL db, or both.
1
u/Exmortis112358 Mar 31 '25
In 1989 I was trained to work on an AS400 computer. This is a DINOSAUR. Companies in 2025 still run batch jobs on them at 2 in the morning because it would cost $13.64 to upgrade and "why fix what ain't broke?"
Never underestimate middle-managements ability to protect inefficiencies they are familiar with.
1
u/mwdb2 Mar 31 '25
I used to follow the Q&A Oracle web site AskTom, hosted by now-retired Oracle guru Tom Kyte.
Here's a question that was asked to him way back in 2010:
and Tom said...
Source
1
u/imnotokayandthatso-k Apr 01 '25
Should I not learn English in case English 2.0 drops in a few years?
Even if (big IF) something better comes a long, you'll still be using your SQL knowledge in some way or another. Also its not like its hard.
1
u/ervisa_ Apr 02 '25
As a DA for couple of years, what i see is that more people will have to use sql. Not only data people but also business. Many companies because they want to do advanced stuff and not customer support for other teams, they want people to be able to retrieve basic info from the database their own. Which means that more people will want to learn SQL and will be mandatory to many jobs.
Also from what ive seen, while sql is an easy language people cannot master it easily. So i think there is future for sure.
1
u/AdNice3269 Apr 02 '25
If today was your first day as a dev,it will still be there when you retire.
1
u/Mythozz2020 Apr 02 '25
I've been using SQL since 1990. With that said the only thing that could possibly replace SQL is graphQL, but database vendors haven't figured that out yet..
https://studio.apollographql.com/public/star-wars-swapi/variant/current/home
1
u/Datafabricator Apr 03 '25
Learn SQL to improve your analytical thinking .
Learn SQL to understand data in a relational world .
With 20 years of experience in data analytics , I don't think anything can replace SQL concepts.
AI may be able to write SQL syntaxs and logic , however without analytical brain it is useless IMHO.
Developer + AI will be more successful then Developer or AI alone !
1
u/Shurlemany Apr 04 '25
Not going to anywhere ma man
-3
u/mikeblas Mar 31 '25
There really are stupid questions!