On: PostgreSQL 11.3 and 10.8

[zerocrates]

I'm not sure what you mean by the "star from one table, specific columns from another" issue... if I'm understanding correctly I'm pretty sure MySQL allows just that.

Division by zero errors and non-"magical" GROUP BY have been the default mode of operation for a _little_ longer, since the 5.7 series.

[oarabbus_ → zerocrates]

Hmm, you're right. Must've been user error on that one ;)

I stand by the rest of my points, however.

[h1d → oarabbus_]

Still mostly the same for MySQL 8?

[oarabbus_ → h1d]

MySQL 8.0 has Window Functions and CTEs. Of the entire list of things I mentioned, window functions and CTE's comprise 80% of the "weight" of my issues of that list.

In other words, while I (or another analyst) would likely still prefer Postgres over MySQL of any version, I wouldn't really have too much to complain about if I was using v8.