select identity_email_id
from auth.email_validation
where email_validation_public_id = $1::uuid
--
select
        identity_public_id
        , data
        , i.created_at
from auth.identity            i
left join auth.identity_email ie using (identity_id)
where ie.identity_email_id = $1;
