I mean, everything is representative if you just phrase the bits you don't want to do as "some trivial op". By this logic, Clickbench is a great and totally representative benchmark because joins are also trivial ops.
Billions of dollars are spent processing semi-structured data. It's a critical part of most analytical pipelines. You can't just ignore it and pretend like your benchmark is representative.
1. operates on very small dataset (100M rows) with very low cardinality
2. It has very limited ops, trivial group by and aggregation
TPC benchs are way more diverse.
> It's a critical part of most analytical pipelines. You can't just ignore it and pretend like your benchmark is representative.
It is not ignored. All major DB engines provide utilities to work with json integrated into relational paradigm. Not sure what is your point.