I once created a partial solution, where the query result is cached and is automatically & incrementally updated using the change-data. I am recently thinking properly implement it, most importantly adding support for join and subqueries. I think it is kind of https://materialize.io/ but for client side apps. Is there a need for this?