[CT-2834] [Bug] Unable to convert deprecation warnings to errors

[dbeatty10]

Is this a new bug in dbt-core?

• I believe this is a new bug in dbt-core
• I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

PASSing console output and a zero exit code instead of the expected behavior below.

Expected Behavior

WARN_ERROR_OPTIONS gives a mechanism whereby users can promote these warnings to actual runtime errors, and I expected a red FAIL message in the console output and a non-zero exit code.

Steps To Reproduce

models/my_model.sql

{{ config(materialized="table") }}

select 0 as id

models/_models.yml

models:
  - name: my_model
    deprecation_date: 1999-01-01

I was hoping for both of these to error out and have a non-zero exit code:

dbt --warn-error run
echo $?

dbt --warn-error-options '{"include": ["DeprecatedModel"]}' run
echo $?

Relevant log output

No response

Environment

- OS:
- Python:
- dbt: 1.6.0rc1

Which database adapter are you using with dbt?

postgres

Additional Context

No response