Push queries

[purplefox]

Currently we use push queries internally in order to compute rows to update a materialized view.

We could also allow users to execute push queries from their applications and have their applications receive streams of results.

For example, an application could execute a query to receive any updates from a customer's account by executing the following push query:

select * from customer_balances where customer_id=12345

Where customer_balances is a MV which maintains customer balances.

As the customer's account balance changes the app would be sent changes where it could render them.