All the data would be available and joining it would be possible with some jsonb gymnastics but its optimized more for compliance style auditing than rapid look

All the data would be available and joining it would be possible with some jsonb gymnastics but its optimized more for compliance style auditing than rapid lookups for complex queries. For that scenario replicating audit data to a OLAP system may be a better fit