HAVING a Blunderful Time (or Wish You Were WHERE) (2007)

The master pattern for this sort of thing is probably Babbage arguing with Stephenson about whether a broader gauge would have been better for railroads. Undoubtedly Babbage had the right of it in the sense that if one were starting a railroad system from scratch the broader gauge would have been better. But beyond some established base of rail mileage, it really didn't matter.

WHERE filters input rows<p>HAVING filters produced rows<p>Questions?

Misleading title. Should be more like, &quot;random whining about SQL&quot;<p>SQL is like democracy: it&#x27;s the worst form, except for every other.<p>Go try writing non-trivial queries in any other database query language, then come back and whine to me about SQL.<p>Notably, SQL hides the implementation in a way that allows for 1000+x speedups from index selection, JOIN order optimization, execution method and parallelism. Typically, even hand-coded queries can&#x27;t touch the performance because of gonzo low level optimizations nobody would bother writing for one query, such as optimizing batch size to match cache size.<p>Modern SQL (e.g. Postgres) even does this while allowing the user to include unmodified business logic written in a variety of high level languages. For example, if you want to search for employees that match some crazy predicate written in (JavaScript&#x2F;Python&#x2F;etc) no problem, it fits right into the WHERE clause, and is executed in parallel on each core of each node. You can even index the results of this function, so the storage system doesn&#x27;t even look at non-matching records... assuming this index is the more selective of the options, which it dynamically decides per query.<p>tl;dr: quit your whining