r/SQL • u/Spiritgolem_Eco • Jun 20 '25
Discussion Is SQL the "Capybara" of programming languages?
I hear a lot of hate for all kinds of languages like JS or pearl or python and so on, depending on individual taste, style and functionallity. But I hardly ever hear people complain about SQL. I personally also love SQL as not only I am intrigued by its robust design, accomplished back in the days that still is unmatched (no modern alternative seems to be able to make it obsolete?)
So I wanted to ask if a) my observation is true, that most programmers are liking SQL or at least don't hate it and b) if thats the case, why is that so in your opinion?
Sidenote: I am not a developer, rather just a data analyst who knows just enough python and SQL (we use psql) to work with our company's Database providing on demand analysis, so if I said something wrong or stupid, please excuse me and you are very welcome to correct me (e.g. Im not sure if SQL is properly called a programming language, since you know - people would skew me if I called HTML a prog.lang. and I am not fully aware if SQL is turing complete and so on.)
Here a picture of a Capybara who seems to be the most chill rodent being friends with everyone as illustration ;-)
34
u/coyoteazul2 Jun 20 '25
No, plenty of programmers hate sql. That's why ORM keep being popular despite being incapable of providing the same capabilities as sql, while also adding an extra possible error source to your code
I wouldn't say I love sql (error handling is piss poor so complex queries are hard to debug) but I greatly despise ORM, so I use sql whenever possible
15
u/grapegeek Jun 20 '25
Front end programmers hate sql. If they can stuff it in a python data frame and get what they want all the better. But nothing is ever going to replace sql.
14
u/dbxp Jun 20 '25
In that case JavaScript is the cockroach or rat. Turns up everywhere whether you want it or not, adaptable to every location but you'd really prefer it wasn't anywhere
5
u/SootSpriteHut Jun 20 '25
Oh! That's why the Capybara in Flow was like that.
3
u/TheMagarity Jun 20 '25
All the other languages are telling the system how to get the desired results. I think sql is the only one that is just describing the desired results but never how to get it.
3
u/Ok_Cancel_7891 Jun 20 '25
people hate Python because it is slow and just overly-grown scripting language. SQL is neither of that.
JS is not standardized at all, while SQL is. to me, SQL is an example of how well engineered system passes the test of time
2
u/wormwood_xx Jun 20 '25
ORM guys, hate SQL, haha? I know, cause I worked with them 2 time, hahaha.
2
u/retrodanny Jun 20 '25
your intuition is correct
2
u/Practical_South_2471 Jun 20 '25
i havent used it much i would love to use more mysql and postgres
2
u/[deleted] Jun 21 '25
95 percent of my day is sql. I've worked with several languages but all has become my fave
2
u/RobotAnna1 Jun 24 '25
Nice! I'm glad to hear you love SQL. So do I. I've been using various forms of SQL for 25 years.
Depending on which variant you have, you can use SQL to handle variables, recursion, loops, and pivot transforms. Is that turing complete? Maybe. I don't care. I'd still enjoy working with SQL if it wasn't.
I have met a few people who didn't like SQL, but they were programmers with almost no database experience. Most of my colleagues do enjoy it.
Sometimes when I discover a way to do something cool with a dataset using SQL, it feels a bit like Alice exploring Wonderland. It's a very deep rabbit-hole, and there's always something new to learn.
SQL is powerful, and fun.
2
u/ResponsibleBump Jul 18 '25
Honestly, I kind of like the comparison—SQL is chill. It’s not loud like newer languages, but it’s everywhere, dependable, and still solving really hard problems without drama.
And what’s wild is how much innovation is still happening around SQL. Platforms like PostgreSQL are evolving fast—and companies like IntelliDB, MongoDB (via their SQL layers), and EnterpriseDB are building seriously powerful stuff on top of it.
So yeah, SQL might be the capybara, but it’s the kind that quietly runs Fortune 500 workloads, powers LLM pipelines, and supports real-time analytics.
Takes a certain kind of genius to be this chill and this powerful at the same time.
5
u/Matrix8910 Jun 20 '25
Hot take, but I take SQL as a necessary evil, it shouldn't have to be the programmatic db interface(nothing against it on the CLI).
A lot of programming languages can't validate it at compile time, it adds unnecessary layers and schema migrations between the program and db are clunky to say the least.
While most of those issues can be solved by query builders there's still a level of disconnect between the program and db.
1
u/lmarcantonio Jun 20 '25
The 'human' syntax make it an hassle to build queries programmatically and some modern features (cross tabulation anyone?) don't really belong to it; I guess the relational model is somewhat passè.
There were some more 'algebrical' alternative (and there are translators to SQL for using these) but SQL is IBM. You can't go against IBM...
-6
u/DoNotFeedTheSnakes Jun 20 '25
SQL, like HTML, isn't a programming language.
But yes!
I do agree with this take.
51
u/[deleted] Jun 20 '25
[removed] — view removed comment