SELECT ... FOR JSON
direct_select_statement_multiple_rows : query_expression [vext_for_json]
vext_for_json -- v5.5 : FOR JSON
This is a Valentina SQL extension to output cursor into JSON format. It returns cursor with 1 record and 1 TEXT field, which contains generated JSON.
Example
SELECT * FROM tblPerson FOR JSON
{ "name": "tblPerson", "fields": ["fldID","fldFirstName","fldLastName"], "records": [ [1,"John","Bishop"], [2,"Mike","Anderson"] ] }