Switch to: V12V11V10V9V8V7V6V5

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"]
    ]
}