feat!: Support psycopg[binary] under a new postgres extra

[edgarrmondragon]

Updated Docs:

• https://deploy-preview-7981--meltano.netlify.app/guide/v3-migration/
• https://deploy-preview-7981--meltano.netlify.app/guide/advanced-topics/#installing-optional-components
• https://deploy-preview-7981--meltano.netlify.app/reference/settings#how-to-use-2

About the psycopg 3 SQLAlchemy driver:

This driver is different enough from its psycopg2 predecessor that SQLAlchemy supports it via a totally separate dialect; support for psycopg2 is expected to remain for as long as that package continues to function for modern Python versions, and also remains the default dialect for the postgresql:// dialect series.

https://docs.sqlalchemy.org/en/20/dialects/postgresql.html#module-sqlalchemy.dialects.postgresql.psycopg

[netlify]

✅ Deploy Preview for meltano ready!

Name	Link
🔨 Latest commit	1fd3152
🔍 Latest deploy log	https://app.netlify.com/sites/meltano/deploys/64cd4f92226ed800088bc3a9
😎 Deploy Preview	https://deploy-preview-7981--meltano.netlify.app
📱 Preview on mobile	Toggle QR Code... Use your smartphone camera to open QR code link.

---

To edit notification comments on pull requests, go to your Netlify site configuration.

[codecov]

Codecov Report

Merging #7981 (1fd3152) into cloud (1502ad6) will increase coverage by 0.01%.
The diff coverage is 100.00%.

@@            Coverage Diff             @@
##            cloud    #7981      +/-   ##
==========================================
+ Coverage   90.43%   90.44%   +0.01%     
==========================================
  Files         283      284       +1     
  Lines       21124    21149      +25     
  Branches     2342     2345       +3     
==========================================
+ Hits        19103    19128      +25     
  Misses       1674     1674              
  Partials      347      347              

Files Changed	Coverage Δ
tests/conftest.py	92.15% <100.00%> (+0.15%)	⬆️
tests/fixtures/db/postgresql_psycopg3.py	100.00% <100.00%> (ø)

📣 We’re building smart automated test selection to slash your CI/CD build times. Learn more

[tayloramurphy]

Nice update - Docs look good too!