> I think JSON support will improve, but SQLAlchemy for example is ok with a common JSON interface over mySQL and Postgres.

This works extremely well with Postgres. The MySQL one is I think just saving it as a text string, which may become a killer.