For important analytics, people may want a dashboard that is constantly updated in real-time.
Using the same SQL repeatedly to refresh the results may consume a lot of resources.
Streaming databases such as https://github.com/singularity-data/risingwave can incrementally compute the latest query results without rescanning the whole data again, and only do work that is porpotional to the size of data changes.
This may take real-time analytics on Dune to a whole new level.