Split mysql_remote_database setting at environnement level

Let’s say I want to work with a local database on my dev environnement and with a remote database on the staging and production environnements. Is there a way to do this with the current setup without having to change the mysql_remote_database setting each time I go back to dev?

If not, would that be a good idea to propose it as an enhancement?

All you need to do is define your remote db credentials for your WP site for staging and production. See https://roots.io/trellis/docs/wordpress-sites/#common for the variables.