Postgres 18+ comes with OAuth 2.0 support: https://www.postgresql.org/docs/current/auth-oauth.html

We have an existing IdP that supports OAuth 2.0 and being able to use it for auth would be much more secure than having to manage usernames and passwords.