MATRIX

Keyword MATRIX

result modifier for a SELECT

Syntax:

    MATRIX OF SELECT ...

Alternative syntax:

    SELECT MATRIX ...

Usually AlaSQL returns array of records (JavaScript objects), but you can modify SELECT statement to return a matrix (array of arrays) of values from the recordset. Row order is as requested in the select.

You can set query modifier for all SELECTs:

    alasql.options.modifier = 'MATRIX';

See also: RECORDSET, VALUE, ROW, COLUMN