> you’ll inevitably come up against a situation where a custom query gets the job done better In my experience, these are typically best turned into views (or

> you’ll inevitably come up against a situation where a custom query gets the job done better In my experience, these are typically best turned into views (or materialized views), because they represent some fundamental relationship or property within the data that’s useful to be able to quickly reference or query directly against. KPI aggregates, for example.