[FEATURE]: Reverse/Down Migrations

### 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

Currently there is no way to reverse a migration with a CLI command. [This 3rd-party package](https://www.npmjs.com/package/@drepkovsky/drizzle-migrations) adds that functionality but it would be amazing to see this as an official feature of drizzle-kit.

Down migrations are a feature that users have been asking for:
- https://www.answeroverflow.com/m/1247174382774779914
- https://www.answeroverflow.com/m/1110868368581464104
- https://stackoverflow.com/questions/78745661/anyway-to-migrate-down-in-drizzle