SELECT "id" AS search_id, tilores.entity: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
  FROM (SELECT "id" FROM orders LIMIT 1),
  LATERAL (SELECT tilores_entity_by_record_id("id") AS entity) AS tilores,
  LATERAL FLATTEN (INPUT => entity:records) AS record;