select user_id from cc_users where upper(screen_name) = upper(:screen_name)
select email from parties where party_id = :party_id
select group_id from groups where group_name = :name
select first_names, last_name
from persons
where person_id = :person_id
update persons
set first_names = :first_names,
last_name = :last_name
where person_id = :person_id
select first_names||' '||last_name as person_name
from persons
where person_id = :person_id
select attr_value as bio
from acs_attribute_values
where object_id = :person_id
and attribute_id =
(select attribute_id
from acs_attributes
where object_type = 'person'
and attribute_name = 'bio')
insert into acs_attribute_values
(object_id, attribute_id, attr_value)
values
(:person_id, (select attribute_id
from acs_attributes
where object_type = 'person'
and attribute_name = 'bio'), :bio)
update acs_attribute_values
set attr_value = :bio
where object_id = :person_id
and attribute_id =
(select attribute_id
from acs_attributes
where object_type = 'person'
and attribute_name = 'bio')
select user_id,
username,
authority_id,
first_names,
last_name,
first_names || ' ' || last_name as name,
email,
url,
screen_name,
priv_name,
priv_email,
email_verified_p,
email_bouncing_p,
no_alerts_until,
last_visit,
second_to_last_visit,
n_sessions,
password_question,
password_answer,
password_changed_date,
member_state,
rel_id
from cc_users
where user_id=:user_id
update users
set [join $cols ", "]
where user_id = :user_id
select user_id
from users
where username = :username
and authority_id =:authority_id
update parties
set email = :email,
url = :url
where party_id = :party_id