[FEATURE]: Support dynamic config

### 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 need to perform a precheck or retrieve the configuration from the remote server, but Drizzle only supports CJS and JSON formats.

I have two draft proposals for reference:
* support `drizzle.config.mts`
* Next.js `next.config.mts` (https://nextjs.org/docs/app/api-reference/config/typescript#for-commonjs-projects-default)
* Playwright `playwright.config.mts` (https://github.com/microsoft/playwright/blob/9d40b1ad20ad5113ce285028715addeb3bddf63b/tests/playwright-test/loader.spec.ts#L247)
* support `defineConfig(config: () => Promise)`
* Vite (https://vite.dev/config/#async-config)

No source file, test, or entry point is named. Compare the existing CJS and JSON configuration behavior with the referenced Next.js, Playwright, and Vite proposals, then clarify which dynamic-config forms are in scope and what successful loading and precheck behavior should be tested.

Written by the indexing model from the issue text.