Composite commands to make things faster and easier

In certain situations in real life apps, it would be useful to have more composite commands like "INSERT INTO ... SELECT ..." and the INSERT ... ON DUPLICATE KEY ... ". Like "SELECT ... FROM INSERT ..." which could return multiple new autoinc values inserted (and maybe after triggers run). Or at least have the function that returns the last autoinc value to return the key when there is an "ON DUPLICATE KEY..." situation. This way checking if something is there and getting it could be done in one command insted of two. If you're open to thees kinds of small SQL changes, I can provide some other examples too.