Inconsistent json data is exactly why you use a json data type or database. I know that you, dear developer, would never produce inconsistent data. But lots o

Inconsistent json data is exactly why you use a json data type or database. I know that you, dear developer, would never produce inconsistent data. But lots of other developers do. It is often the case that you will need to query that inconsistent json data, but either the pain is too great, or the value too low, to normalize that data. Thus, you dump it as is into a json field or database.