Convert Array Column (String Datatype) into another table

Hi, in one of the tables in my database one of the columns are presented like this.

"{"id":"000000000000000000000000","tracking_number":"","title":"","origin_country_iso3":null,"destination_country_iso3":null,"shipment_package_count":0,"active":false,"order_id":null,"order_id_path":null,"order_date":null,"customer_name":null,"source":"","emails":[],"custom_fields":{},"tag":"Pending","tracked_count":1,"expected_delivery":null,"signed_by":"","shipment_type":null,"tracking_origin_country":null,"tracking_destination_country":null,"tracking_account_number":null,"tracking_postal_code":"","tracking_ship_date":null,"tracking_key":null,"tracking_state":null,"created_at":"2021-05-07T08:41:13+00:00","updated_at":"2021-05-07T08:41:13+00:00","slug":"","unique_token":"","checkpoints":[]}
"

I would like to convert this array into another table, or even better insert these new columns into the existing table. How would this be possible? What kind of query or function would expand this array.

Thanks

Hi @natti
You would do that in a View on your database - since you don't write which database you're using, then have a look at this - otherwise try searching in a forum specific to your database:
https://stackoverflow.com/questions/57620135/postgres-array-of-arrays-to-columns