[Feature] Spike on supporting Py3.12 in dbt-spark

[colin-rogers-dbt]

Is this your first time submitting a feature request?

• [X] I have read the expectations for open source contributors
• [X] I have searched the existing issues, and I could not find an existing issue for this feature
• [X] I am requesting a straightforward extension of existing dbt-spark functionality, rather than a Big Idea better suited to a discussion

Describe the feature

We need to try upgrading to py312 and either it works with minimal changes or scope out what needs to happen to make it work

Describe alternatives you've considered

No response

Who will this benefit?

No response

Are you interested in contributing this feature?

No response

Anything else?

No response

[VersusFacit]

We need to bump pydobc to 5.0 or higher (included in my PR alreadt).

Pre 5.0 does not come with wheels per the official repo.

official repo SO

This ticket will be blocked until the apache spark netcat issue breaking apache-spark is solved.

Thankfully, other tests are running just swimmingly 🏊‍♀

Because spark uses 3.12 for most non test release functions, I really just need to run through local operations and CI to get a safe merge, I think.