update persons set [join $cols ", "] where person_id = :person_id update acs_objects set title = :first_names || ' ' || :last_name where object_id = :person_id update users set [join $cols ", "] where user_id = :user_id select user_id from users where lower(username) = lower(:username) and authority_id =:authority_id update parties set [join $cols ", "] where party_id = :party_id update acs_objects set title = :email where object_id = :party_id and object_type = 'party' select party_id from parties where lower(email) = lower(:email) select name from organizations where organization_id = :party_id select group_name from groups where group_id = :party_id select party_name from party_names where party_id = :party_id select user_id from users where lower(screen_name) = lower(:screen_name)