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)
Did you mean to remove the call to `super`?