[FEATURE (v1)]: `--explain` option for `drizzle-kit migrate`

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

In the beta version, the `drizzle-kit push` command now have `--explain` option, allowing users to preview the SQL that will be executed. This is an excellent way to balance speed and safety.

However, `drizzle-kit migrate` still does not have a similar option. We lack a clear way to know which migrations have already been applied to a production database (the `__drizzle_migrations` folder contains this history, but it's written in hashes and is impossible to read). Providing an `--explain` option for `drizzle-kit migrate` that displays a list of migrations to be applied would enable a safer schema migration flow.

Thanks for all the hard work from the drizzle team!