Support for views

[lulco]

ideally structured use like in tables:

$this->view('view_name')->columns(['list of columns'])->select() etc.

• create view
• update (replace) view
• drop view
• rename view
• dump view
• tests
• documentation about views

[JohnWE]

Yes, as you say, views are often complex queries that the client wants to run repeatedly. Lots of joins. So plain SQL is fine with me.