[steve-chavez]

> why isn't someone rolling those tables into something a bit easier with some backend process.

To put it in more concrete terms(plain SQL): the tables could be aggregated on a set returning function or a view.

[cgh]

Yes, in these situations materialized views with indexes are generally the correct answer.