Advanced Snowflake query to Tilores to gather data insights

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;