if you have data stored as json in a column, you could query the data by
select * from TABLE where json_column['name'] = 'Bob'
select * from TABLE where parse_json(json_column::variant):name:varchar = 'Bob'
Are these equivalent in performance?
This question is not yet answered, be the first one who answer using the comment. Later the confirmed answer will be published as the solution.