SET user_id_arg = select id from users where username = sqlpage.user_info('preferred_username');
SET user_accessible_variable = sqlpage.run_sql('API/apiEndpoint.sql', json_object('user_id', $user_id_arg));
select 'table' as component,
 sqlpage.user_info('preferred_username') || '''s Access' as description,
 '#_edit_form_modal?action=edit&update_id= {id}' as edit_url,
 '#_edit_form_modal?action=delete&delete_id={id}' as delete_url;
 select * from (sqlpage.run_sql('API/apiEndpoint.sql', json_object('user_id', $user_id_arg))); -- doesn't work in sqlpages.
 
 select * from $user_accessible_variable -- runs but returns an array of key, value,full path, etc with all object literal results in value -- can not parse object literals from value as json_extract and json_each get jammed up on each other. Couldn't set array to variable and then extract against the variable either.
SELECT
 id,
 name,
 description,
etc
FROM
 other code
 WHERE user.user_id = $user_id_arg
 ); -- runs, provides clean object literals.