OP here. Great points -- especially around MySQL and subqueries, which has been a frustration for us.
Comparing across different RDBMS's is a great idea. Maybe we can squeeze it into a future blog post. :)
Comparing across different RDBMS's is a great idea. Maybe we can squeeze it into a future blog post. :)
[1] https://news.ycombinator.com/item?id=7119976 or http://ta.speot.is/2014/01/25/use-subqueries-to-count-distin...