select
        i.identity_public_id
        , s.created_at
        , s.expires_at
        , s.revoked_at
from secd.session  s
join secd.identity i using (identity_id)
where secret_hash = $1;
