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

[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-postgres 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