Dynamic table based on JSON column

Thanks again, very valid points. We tried this as well, and display it in a matrix so it 'looks' like a table. It is as close to a solution as possible.

I will try to attach some data here for exploration.

The complete use-case is the following (I should have explained better in the original post):

We have records from different entities that fail some validation criteria.
(let's say 100 entities in total, each entity with 20 columns, each entity containing 500 failing records)

We will never show a single table for different entities together, we will first filter on each entity separately.

Once the filtering is done, we want to display all the records of this entity in an expanded table.

We could build one report per entity, expanding all its JSON columns, but this is too cumbersome.

Hence the need to filter 1st, and then display the expanded table.

Any thoughts?