I need to get the fields from JSON that is stored in VARCHAR. In addition this should be done within one SELECT statement without wrapper.
What I need(this is obviously not a valid sql, just for clarification of what I need):
The following code is unacceptable:
(SELECT CONVERT_FROM(column_in_varchar, ‘JSON’)
Do you have any ideas?