[Python 3.12] Support + test against python 3.12 in dbt-adapters

[MichelleArk]

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-adapter functionality, rather than a Big Idea better suited to a discussion

Describe the feature

Python 3.12 was released in October 2023: https://www.python.org/downloads/release/python-3120/

Let's ensure dbt-adapters supports 3.12 & tests against it as part of its testing matrices

Describe alternatives you've considered

No response

Who will this benefit?

all dbt-core users as this would (in part) unblock dbt-labs/dbt-core#9007

Are you interested in contributing this feature?

yes!

Anything else?

https://docs.getdbt.com/faqs/Core/install-python-compatibility

“New dbt minor versions will add support for new Python3 minor versions as soon as all dependencies can support it. In turn, dbt minor versions will drop support for old Python3 minor versions right before they reach end of life.”

With 3.11 Spark was the challenging one.

[MichelleArk]

The dbt-core issue is complete (dbt-labs/dbt-core#9007), which means we are implicitly testing that dbt-adapters works with Python 3.12 as a dependency of dbt-core.

The remaining work here should be a relatively small lift:

• a matter of adding it to the test matrix here:

  dbt-adapters/.github/workflows/unit-tests.yml

  Line 26 in b65b761

  python-version: ["3.8", "3.9", "3.10", "3.11"]

• updating the classifiers here: https://github.com/dbt-labs/dbt-adapters/blob/main/pyproject.toml#L14