[FEATURE]: Generate TypeScript enum instead of array of strings when running `drizzle-kit introspect`

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

Now that `pgEnum` and `mysqlEnum` have [more useful functionality](https://github.com/drizzle-team/drizzle-orm/releases/tag/0.42.0) in the latest version of Drizzle, it would be great if drizzle-kit would default to generating TypeScript enums instead of arrays of strings when running `introspect`, so that we can use this functionality without making manual changes to the schema each time `introspect` is run.

Alternatively, perhaps this behavior could be controlled by a config setting.