[Feature] support psycopg (major version 3 of psycopg2)

[dataders]

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

Describe the feature

https://www.psycopg.org/articles/2024/06/30/psycopg-32-released/

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

[MatthijsKok]

Python 3.14 was released yesterday. Since psycopg2-binary does not support 3.14 while psycopg does, users of dbt-postgres are currently unable to upgrade to Python 3.14

[MatthijsKok]

Support for Python 3.14 in psycopg2-binary pending in psycopg/psycopg2#1802