SELECT entity.value:id::STRING AS entity_id, record.value:data:id::STRING AS entity_record_id, record.value:data:first_name::STRING AS first_name, record.value:data:last_name::STRING AS last_name, record.value:data:name::STRING AS name, record.value:data:payment_default::BOOLEAN AS payment_default FROM (SELECT tilores_search({'name': 'John Smiith'}) AS entities), LATERAL FLATTEN (INPUT => entities) AS entity, LATERAL FLATTEN (INPUT => entity.value:records) AS record;