George Leonard
08/28/2025, 11:03 AMINSERT INTO c_paimon.outbound.children
SELECT
JSON_VALUE(data, '$._id') as _id,
JSON_VALUE(data, '$.name') as name,
JSON_VALUE(data, '$.surname') as surname,
JSON_VALUE(data, '$.gender') as gender,
JSON_VALUE(data, '$.dob') as dob,
JSON_VALUE(data, '$.nationalid') as nationalid,
JSON_VALUE(data, '$.family_id') as family_id,
JSON_VALUE(data, '$.father_nationalid') as father_nationalid,
JSON_VALUE(data, '$.mother_nationalid') as mother_nationalid,
ROW(
JSON_VALUE(data, '$.address.street_1'),
JSON_VALUE(data, '$.address.street_2'),
JSON_VALUE(data, '$.address.neighbourhood'),
JSON_VALUE(data, '$.address.town'),
JSON_VALUE(data, '$.address.county'),
JSON_VALUE(data, '$.address.province'),
JSON_VALUE(data, '$.address.country'),
JSON_VALUE(data, '$.address.country_code'),
JSON_VALUE(data, '$.address.postal_code'),
JSON_VALUE(data, '$.address.parcel_id')
) as address,
created_at
FROM postgres_catalog.inbound.children;Andreas Bube
08/28/2025, 11:15 AMGeorge Leonard
08/28/2025, 11:37 AM