What did you dislike about connecting to Postgres from AWS lambda?

You have to build the driver. And sometimes libc version on lambda runtime is slightly different from libc that is linked to the driver.

Overall there was a lot of trial and error and no clear way to test everything locally in the container.