Integrating pgroll into databases that use views

[kvch]

pgroll gives access to multiple schema versions by hiding tables behind views. At the moment, pgroll does not have a way to provide access to multiple versions of the same view.

Open questions

• Is this something we want to support?

Views are not materialized, so changing them does not qualify as an "unsafe" or tricky migration. The only use case I see for view support is when two application versions use the same view, but with different base query. So providing two versions of the same view could be useful.

• How to tell apart old and new version of the view?

We can add a new view to the new schema, similarly to tables.