Reading about multiple projects on Twitter that provide a metrics layer against the database. For example - dbt metrics, Transform, Supergrain. Thoughts from what I make of it below.
The product webpages use the term Headless BI or metrics layer, none of them super informative. I'd expect the pitch roughly goes like this.
This was prompted by looking at multiple tools for data exploration and analytics, for ex - Datablocks, Basis Data and more. A common substrate across many of these is an infinite canvas, where you write small bits of functionalities in nodes and then wire them together to model data flow. A visual workspace allows richer interactions and visual tooling that are hard to replicate with a text based IDE.