DELETE ... RETURNING Cool! The ability to fetch the result of a write operation without having to do a SELECT afterward is one of my favorite "minor perks" of

DELETE ... RETURNING Cool! The ability to fetch the result of a write operation without having to do a SELECT afterward is one of my favorite "minor perks" of PostgreSQL. It eliminates the need for a lot of extra queries. With MariaDB 10.0, only DELETE statements get the RETURNING clause. But it seems that they have plans to add it to UPDATE statements soon [1], and I hope INSERT gets it as well. [1] https://mariadb.atlassian.net/browse/MDEV-5092 https://mariadb.atlassian.net/browse/MDEV-5092