RDS now has data API, and data API can be used. However, data API has a lot of limitations like only scram-sha-256 authentication is supported for Postgres Aurora 14 and up. Read the docs page for details.
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/data-api.html