Enhancement: Language support for transactions

Defect Tracker #20222: Supporting a limited transaction syntax, possibly similar to http://dev.mysql.com/doc/refman/4.1/en/commit.html, would allow the writers of virtual stored procedures to have declarative transaction handling rather than being forced to use the same transaction settings for all procedures based upon connection properties.