support MySQL and PostgreSQL extended DELETE syntax

note that this also adds support for limit on all adapters by doing a subquery (just like update)
I did not. probably got confused in the conflicts when I rebased