[FEATURE]: Add --quiet / CI-friendly flag to disable TTY spinners and use plain output

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

When running drizzle introspect in CI pipelines, the current output floods logs because it prints continuous spinner updates intended for interactive TTY terminals. Many CI environments either allocate a pseudo-TTY or do not properly suppress this output, resulting in very noisy logs.

It would be helpful to have a --quiet, --no-spinner, or --ci flag that disables the animated progress output and only prints a clean, single-line summary of each step. Ideally, drizzle-kit would automatically detect non-TTY or CI=true and fall back to plain logging, but a manual flag would give users explicit control.

Example CI output, nearly 2000 lines long: