This isn't widely known, but activity schema[1] is aiming for this space (disclosure - I co-founded the company supporting it). It's a modeling approach that s

This isn't widely known, but activity schema[1] is aiming for this space (disclosure - I co-founded the company supporting it). It's a modeling approach that separates data modeling from data querying -- meaning that once data is modeled, it can answer any number of questions. The base building blocks of the data model can be combined at query time without having to figure out explicit foreign key joins. [1] https://www.narrator.ai/activity-schema/ https://www.narrator.ai/activity-schema/