Add new materialized views for heatmaps on 8knot (and make a system for it)

> [!NOTE]
> Migrated from [augurlabs/augur#3761](https://github.com/augurlabs/augur/issues/3761)
> Originally opened by `@cdolfi` on 2026-03-04

---

https://github.com/oss-aspen/8Knot/pull/1086 these materialized views need to be added to augur

This is a combination of adding the materialized view (example)
https://github.com/chaoss/augur/blob/b277c0a848c7d105ebeb7514aab2ccba10d782a3/docker/database/augur-new-schema.sql#L2674

and refreshing it
https://github.com/chaoss/augur/blob/main/augur/tasks/db/refresh_materialized_views.py