I've been missing many of these features from Postgres and they are finally becoming a reality in MySQL.