Indexing
the JSONB
ISOK_RESULTS.QR_Extra column improves performance.
If you know your JSONB
keys, you
can make a VIEW
that exposes the value of those keys as the view's
columns.
Users of this view would not have to be familiar with querying
JSONB
.
More complex schemes involve putting a row-level BEFORE trigger on ISOK_RESULTS to distribute the various values appearing in ISOK_RESULTS into other tables. But doing so surely takes you past the point of diminishing returns. It is easier to modify the SQL that Isok installs. And doing so is probably also less of a long-term maintenance burden, which matters.