Query other query results

Make query results a valid datasource. Slow queries can be scheduled, and its results used on other queries. I've seen this implemented and is very useful. This allows for fast dashboards on slow queries because the slow queries are somewhat cached in the system. You can require a certain sql dialect like sqlite or any other.