alt Hacker NewsUse the term, never define the term, classic.
CTE stands for Common Table Expressions in SQL. They are temporary result sets defined within a single query using the WITH clause, acting like named subqueries to improve readability and structure.
Replies
While generally a fair critique, the site does have "SQL" in its name.
Agreed. I was relieved to see this wasn’t written by Cam Skatteboro.
Eh, almost every link on the homepage has an initialism or acronym in the title, and roughly none of them are actually defining the term they're using. Indeed, not to point fingers, your own submissions make the same mistake.
Sure, yes, OP should (and now has) defined the term. But at the same time it's reasonable to expect that someone reading a blog post on BoringSQL.com would already know the term just as much as we could expect people interested in Clojure would know what a REPL is.
Your comment could have been more helpful without the first sentence. SAME content, same correction, less superiority: "CTE is an overloaded term, in this article ......"
This is a valuable comment, don't ruin it with sarcasm and rudeness.
OP here, damn - that's a very good point. Can't believe I missed it.