We don't need no steenking pivot

tv2.sql

create temp view tv2 as select
 b.did as id,
 (select a.value from namevalue as a where a.name='first' and
a.did=b.did) as first,
 (select a.value from namevalue as a where a.name='last' and
a.did=b.did) as last,
 (select a.value from namevalue as a where a.name='uid' and
a.did=b.did) as uid,
 (select a.value from namevalue as a where a.name='displayname' and
a.did=b.did) as displayname,
 (select lower(a.value) from namevalue as a where a.name='displayname' and
a.did=b.did) as lowername
from
 (select did from namevalue group by did) as b ;