Sure, if you use a field often it is most likely better to extract it into a column with auto-updates from the JSON data.

But you have to tune it and see what is best for your use case. Just saying that you can add indexes to JSON fields as well!

And you can add indexes on those JSON fields too!

It is almost like having strong consumer protection rights means the corporations can’t do what they want. No, must be socialism! /s