[Feature] Use --quiet by default for dbt show

[dbeatty10]

Is this your first time submitting a feature request?

• I have read the expectations for open source contributors
• I have searched the existing issues, and I could not find an existing issue for this feature
• I am requesting a straightforward extension of existing dbt functionality, rather than a Big Idea better suited to a discussion

Describe the feature

As described in #9840, It is often useful to pipe or redirect JSON output of dbt show for further downstream processing with a tool like the Python built-in json.tool or the jq swiss army knife.

It would be nice if the syntax were as simple as this to pipe JSON output to a downstream tool:

dbt show -s my_model --output json | python -m json.tool --json-lines

We'd want the --inline flag to be treated the same way as if --select we given instead.

Describe alternatives you've considered

The problem is that we currently need to do some gymnastics with --log-format, --output, and some downstream filtering to extract the desired JSON object 😢

It's certainly possible to require usage of the -q / --quiet flag, but it would be harder for folks to discover that way. If someone passes --output json, they probably want only JSON.

Who will this benefit?

Anyone that want to do any JSON post-processing in a terminal.

Are you interested in contributing this feature?

No response

Anything else?

We'd probably want the same behavior for all three of these subcommands:

• show (assuming a single node is selected)
• compile (when a single node is selected)
• list (regardless the number of nodes selected)

See #7994 for more detail about dbt list specifically.