SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT JSON_ARRAY(
    JSON_OBJECT(
      'command':'setcontext',
      'recordtype':'client',
      'recordid':1030
    ),
    JSON_OBJECT(
      'command':'gotodq',
      'usercode':'react_webuser_debtor_details'
    )
);


(No column name)


[{"command":"setcontext","recordtype":"client","recordid":1030},{"command":"gotodq","usercode":"react_webuser_debtor_details"}]


SELECT '[' + (
    SELECT 
      'setcontext' AS command, 'client' AS recordtype, 1030 AS recordid 
    FOR JSON PATH, WITHOUT_ARRAY_WRAPPER
  ) + ',' + (
    SELECT 
      'gotodq' AS command, 'react_webuser_debtor_details' AS usercode 
    FOR JSON PATH, WITHOUT_ARRAY_WRAPPER
  );


(No column name)


[{"command":"setcontext","recordtype":"client","recordid":1030},{"command":"gotodq","usercode":"react_webuser_debtor_details"}


SELECT 
  'setcontext' AS command,
  'client' AS recordtype,
  1030 AS recordid,
  NULL AS usercode

UNION ALL

SELECT 
    'gotodq',
    NULL,
    NULL,
    'react_webuser_debtor_details'

FOR JSON PATH;


JSON_F52E2B61-18A1-11d1-B105-00805F49916B


[{"command":"setcontext","recordtype":"client","recordid":1030},{"command":"gotodq","usercode":"react_webuser_debtor_details"}]