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.

[xremming]

This has risen as the primary concern for me as I've looked into using pgroll. So a +1 for some solution around views being integrated to pgroll.

[gulcin]

This has risen as the primary concern for me as I've looked into using pgroll. So a +1 for some solution around views being integrated to pgroll.

Thank you for your feedback @xremming.