This is really interesting, as a data analyst and product person I like this embedded data modelling approach.

I would be interested in knowing if you’ve thought about what to do with external data (eg Stripe) and data processing engines (eg Snowflake/Databricks/clickhouse or duckdb)

At this point it would rely on the person embedding it in their app to get that data, put it somewhere, and then add a Cube definition on top of it - so this is purely solving the visualisation / report building part of that puzzle (but in a fully embedded / non iframe way).

Also have a look at cube, I saw some similarity, I much prefer your clean approach https://cube.dev/docs/product/data-modeling/overview

I used Cube as inspiration, and actually the rest API for drizzle-cube is compatible with the cube-js schema definition. The main difference is that I chose to model the cubes in typescript, so they can be validated in the IDE easily (autocomplete, catch issues early) and not have an option for YAML, but the semantics are exactly the same.