Versions of a Project

[inbytesdevteam]

I know there are some suggestions on having an easy way to Duplicate Projects for staging purposes (#5930). But it would be a nice feature that we don't have to do that anymore just to create a staging or testing environment.

What if there was a way to create one project and it has a way to create different versions for Staging, Testing environments in the project. It has a way to migrate or update the DB as needed to prod with just a click of a button. API URL will be just the same URL except that it has -staging suffix or prefix attached. And have a way to rollback to past DB if possible.

This limit the chances of making a mistakes in migrating/updating the db schema, RLS, etc to another project. This will make sure that the project runs in the same version of Supabase because it's possible that projects can have different versions of Supabase installed.

And would be a game changer because it simplify the process of having multiple projects (for environment purposes) or needing to use other tools like Github Actions to create a workflow connecting two projects together (https://supabase.com/docs/guides/cli/managing-environments).

Just a suggestion. Thanks Supabase Team :)