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

[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 change to existing dbt-semantic-interfaces 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?

No response

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.”