https://softwarepatternslexicon.com/sql/query-design-patterns/using-views-and-materialized-views/