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)
Why are we doing is_a? checks here?