This example shows the JSONExtractValue method returning NULL results. This query gets the job associated with each person.
JSONExtractLargeValue can be substituted for JSONExtractValue.
SELECT eno, edata.JSONExtractValue('$..job') FROM my_table ORDER BY 1;
Result:
ENO edata.JSONExtractValue(…) --------------------------------- 1 programmer 2 ? 3 CPA 4 small business owner