I've implemented this for scalability a few times. In practical terms where I had to use it we ended up with the query portion being fulfilled by a materialize

I've implemented this for scalability a few times. In practical terms where I had to use it we ended up with the query portion being fulfilled by a materialized view that organized & aggregated the data in a way to make the queries feasible in milliseconds instead of minutes or tens of minutes. This pattern can be very important with respect to enormous data sources in the cloud but can even be useful in smaller data sets in "on prem" applications. Like anything though if you try to apply it everywhere that's just bad architecture.