Ability to set up SSH tunnel to Hosted Database

Moving from self-hosted postgres to managed postgres, in the past we relied on using an ssh tunnel to connect to the server because we had access to postgres port locked down and we’ve been using VPN client that has dynamic ip on our end (so can’t lock our local IP down in firewall).

Now with hosted db, we lost ability to get ssh access, which means we can’t configure an SSH tunnel to connect to the postgres.

Any work arounds to still locking down access, but be able to connect to it from a dynamic IP?