[FEATURE]: Drizzle-kit introspect into multiple files

[apetta]

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

It would be great if there was an option for drizzle-kit to introspect the schema into multiple files instead of a single schema file, for better readability.

[l3wi]

Would also love this