Learn SQL Once, Use It for 30 Years

signa111 pts0 comments

Learn SQL Once, Use It for 30 Years | by Fayner Brack | May, 2026 | MediumSitemapOpen in appSign up<br>Sign in

Medium Logo

Get app<br>Write

Search

Sign up<br>Sign in

Learn SQL Once, Use It for 30 Years

The Only Programming Language Built on Mathematics, Not Fashion

Fayner Brack

3 min read·<br>May 13, 2026

Listen

Share

A cross-section of rock strata where the upper layers are cracked and crumbling, each labeled with the names of old web technologies like jQuery, Backbone, Flash, and CoffeeScript. Beneath them sits a single solid slab of bedrock with SQL carved into it alongside the mathematical symbols of relational algebra.

Want to come back later? Save this to readplace.com.<br>Learn SQL Once, Use It for 30 Years | Reader View<br>SQL queries from 1995 run unchanged today because relational algebra never changes. Everything else in software does.

readplace.com

SQL is the only programming language a working developer can learn once and use for 30 years without rewriting their mental model. That claim sounds like nostalgia, but it rests on something more durable.<br>Open any SQL textbook from 1995. Find the example query:<br>SELECT department, COUNT(*) AS headcount<br>FROM employees<br>WHERE hire_date > '1994-01-01'<br>GROUP BY department<br>HAVING COUNT(*) > 5<br>ORDER BY headcount DESC;Paste it into PostgreSQL 18 in 2026. It runs. Same syntax, same result, same mental model. Thirty-one years, zero changes.<br>Now try this experiment with the JavaScript ecosystem. Take a React component from 2015. React.createClass, mixins, componentWillMount. It doesn't just look old, it throws TypeError: React.createClass is not a functionthe moment it loads. You rewrite it from scratch to ship it today. Ten years passed, and the framework cycled through three different mental models in that time.<br>Get Fayner Brack’s stories in your inbox

Join Medium for free to get updates from this writer.

Subscribe

Subscribe

Remember me for faster sign in

I have used SQL at five companies across fifteen years. The query patterns I learned at the first one still work at the current one. I cannot say that about any other language in my stack.<br>SQL endures because relational algebra is mathematics, and mathematics does not have release cycles.

Edgar Codd formalised relational algebra in 1970. SQL sits on top of it as a declarative interface. You describe what you want. The database engine decides how to get it. The engine improves every year. Your query stays the same.<br>JavaScript is an imperative language that browser wars, framework trends, and open-source maintainer preferences reshaped every few years. It rewards you for keeping up.<br>SQL rewards you for sitting still.<br>If you are a junior developer, “learn SQL properly” is the most valuable 40 hours you can spend. Not a tutorial. Not an ORM. Actual SQL: joins, subqueries, window functions, query plans. That investment pays you back at every job, in every stack, for decades. Almost nothing else in software has that half-life.<br>If you are a senior developer, you already know the cost of this stability. SQL has accumulated forty years of warts it cannot easily shed.<br>NULL is a three-valued logic trap that breaks the intuition of most new users. GROUP BY forces you to repeat column lists for no good reason. Date handling is a vendor-specific mess. Each database has its own dialect, and the "standard" is a 4,000-page document that no single implementation fully follows.<br>These are the costs of backwards compatibility chosen over elegance. SQL locked itself into that tradeoff decades ago. Your 1995 textbook still works because the language refused to break old queries. That same stubbornness means the warts are here to stay.<br>Most languages reward you for chasing what comes next.<br>SQL is the rare one that rewards you for learning what is already there.

If you liked this, you might like readplace.com, built for exactly this kind of reading.<br>Thanks for reading. If you have some feedback, reach out to me on LinkedIn, Reddit or by replying to this post.

Sql

Programming

Web Development

Software Engineering

Math

Written by Fayner Brack<br>5.5K followers<br>·0 following

I believe knowledge should be open and free. Since 2015, sharing challenging stuff AI won't tell you. My reading system: https://readplace.com?utm_source=m

Help

Status

About

Careers

Press

Blog

Privacy

Rules

Terms

Text to speech

years learn from language fayner brack

Related Articles