Depending on the backup tech, that can be kind of difficult. I can't run arbitrary SQL against the database backups I've got stored in tarsnap. Nor against tape, etc.
For that matter, isn't the (or one) reason for having a backup so that errant deletes don't obliterate everything?