Make views queryable

[joshua-spacetime]

Specifically from the sql http api. We're not concerned with subscriptions or the websocket api for this ticket. As per the design, queries must assume that the view is materialized and read from the materialized table directly. It should not evaluate the view by invoking __call_view__. We do not have to be concerned about arguments in this ticket either. Calling parameterized views can be implemented separately.

[joshua-spacetime]

Closed by #3570 and #3578.