support Mysql extended DELETE syntax

note that this also adds support for limit on all adapters by doing a subquery (just like update)