[CT-408] [Feature] Database Agnostic error handling

[McKnight-42]

Is there an existing feature request for this?

• I have searched the existing issues

Describe the Feature

Per #4858 (comment) the way we are catching database errors needs to be handled in a way that leverages each databases level of concern for the error or to catch them, and turn them into dbt specific errors and run those against tests

Describe alternatives you've considered

currently catching and lowering error to be read out same way across databases.

Who will this benefit?

potential for all uses to benefit as errors could be written very clearly across all databases.

Are you interested in contributing this feature?

No response

Anything else?

No response

[jtcohen6]

@McKnight-42 The error message we're catching here is specific to the test added in #4858, and it's actually handled in a database-agnostic way there. We'll find out when we convert the test cases to use the new pytest-based framework, and set them up to be inherited and run (with zero code changes) in each of our plugins. Then, we can delete the copy-pasted code that lives in the plugins currently.

I think this can be closed, since the main work is already reflected in #4882