Currently the only supported SSL mode is verify-full or disable but it does not support 'require' or 'prefer'.
For example, to connect to Heroku PostgreSQL instance, it needs to be in 'require' mode.

https://www.postgresql.org/docs/12/libpq-ssl.html#LIBPQ-SSL-SSLMODE-STATEMENTS

If you add those options, it would be a huge help!