Allow fire_event to optionally handle warn_or_error functionality

[QMalcolm]

Housekeeping

• I am a maintainer of dbt-common

Short description

Originally warn_error and warn_error_options was only meant to work with a subset of warnings/errors. However, it has come to be assumed, more often than not, that both flags work with all warnings/errors. As such, we want fire_event to begin handling warn_error and warn_error_options in an opt-in manner. We unfortunately can't just by default turn it on as that might break working dbt projects (i.e. doing so would be a major version bump). At some point in the future the default will be opt-in, and even later we'll likely remove the ability to opt out.

Acceptance criteria

• fire_event handles warn_error and warn_error_options
• the handling of warn_error and warn_error_options in fire_event is opt-in
• warn_or_error should pass through to fire_event with opt-in

Suggested Tests

• by default warn_or_error functionality doesn't run in fire_event without opt-in
• warn_or_error functionality does run in fire_event with opt-in
• old warn_or_error passes through to fire_event

Impact to Other Teams

N/A

Will backports be required?

No

Context

dbt-labs/dbt-core#11116