[CT-1680] Replace deprecated exception functions

[emmyoop]

dbt-core has deprecated functions to raise exceptions in favor of directly raising the exceptions. Nothing should be broken (yet) and the functions still raise as expected but they also will log a deprecation warning (pending dbt-labs/dbt-core#6413). It would be good to resolve these deprecation messages before the 1.4 rc.

There are a lot of deprecated function so it's easier to search for dbt.exceptions and look at each callsite to determine if it's using a function or already directly raising an exception. Then replace anywhere using functions with directly raising an exception.

We can create new exceptions in dbt-core to raise or the adapters could start to own their own exceptions within the adapter code base that inherit from exceptions in dbt-core.

For examples, see dbt-core PR that replaced all functions with raises.