[FEATURE]: Apply only specific migrations with drizzle-kit for automated testing

### 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'd love to have the ability for drizzle-kit to be able to apply only specific migrations to allow for better / nicer automated testing. Some of it could be achieved by just ("manually"? still automatable but not sure what to call it) applying the SQL migration files but then you're not exactly 1:1 with what the real drizzle runtime situation would be. Doing it with drizzle-kit for example however would make the situation the exact same as the real state of things would be.

Poorly worded, hope you know what I mean, please do ask for clarification and I'm open to ideas of alternative solutions if something already exists.