just in case anyone is facing a issue with sslmode=require and you are using:

• neon as db

you will need to add an extra configuration in DataSource

    new DataSource({
    ... current configuration,
    ssl: true,
    extra: {
      ssl: {
        rejectUnauthorized: false,
      },
    },
   })

reference: https://community.neon.tech/t/cannot-connect-to-neon-database/570/7