update persons
set first_names = :first_names,
last_name = :last_name
where person_id = :person_id
update acs_objects
set title = :first_names || ' ' || :last_name
where object_id = :person_id
update persons
set bio = :bio
where person_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
select 1
from registered_users
where user_id = :user_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)
select rel_id
from cc_users
where user_id = :user_id