Move rollback functionality into migration itself.

Provide examples for executing queries, both those that can be rolled back and those that cannot.