How to parse column having JSON data using SQL?

How to parse column having JSON data using SQL?

We have a daily sync from a PostgreSQL database that brings data into Zoho Analytics. Some of the columns store raw JSON data. We need to build SQL queries on top to parse data from JSON and store them in discrete columns. There is no option for "Data Prep" with scheduled syncs and JSONEXTRACT is throwing an unsupported function error. How can we use SQL to get data out cleanly from the column storing JSON data?