db_multirow users get_users "select last_name, first_name, first_name || ' ' || last_name as full_name from ad_template_sample_users"
I have put it in the openacs.org bug tracker a while ago but will put it in the openacs4 bugtracker.