INSERT INTO agent (
    id, shortcode, full_name, credential, credential_type, profile_picture_url, time_created, last_updated
) VALUES (
    $1, $2, $3, $4, $5, $6, $7, $7
) RETURNING
id,
shortcode,
full_name,
credential,
credential_type as "credential_type: _",
profile_picture_url,
time_created,
last_updated;