[FEATURE]: Native support for reverting migration

### Feature hasn't been suggested before.

- [x] I have verified this feature I'm about to request hasn't been suggested before.

### Describe the enhancement you want to request

I have used TypeORM before, which as a ORM typeORM is matured.

Coming to drizzle, one thing TypeORM had but drizzle doesn't have is native reverting of migration.

We have something like query.up and query.down, which will make it easier for rollback cases.

Ref:https://typeorm.io/docs/migrations/generating

The issue names no files or tests; start by reading Drizzle's migration tooling and the referenced TypeORM migration documentation. The requested outcome is native migration reverting with query.up and query.down support, but the issue does not define the surrounding API or test location.

Written by the indexing model from the issue text.