gistfile1.sql

from (
  select 
    transform(full_name, address, email_id) 
      using 's3://<>/parse_name.pl' 
      as (first_name, last_name, address, email_id) 
  from names_table
) t 
select t.first_name, t.last_name, t.address, t.email_id 
where t.last_name like 'Singh';