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