User Defined Functions

User defined functions

To define new functions for SQL simply add it to alasql.fn variable, like below:

    alasql.fn.cube = function(x) { return x*x*x; }
    alasql(‘SELECT cube(x) FROM ?’,[data]);

You can use alasql inside alasql functions, like below:

    alasql.fn.myfilter = function(phase) {
        return alasql('SELECT VALUE COUNT(*) FROM ? WHERE Phase = ?',[data,phase]) == 2;
    };

    var res = alasql('SELECT * FROM ? WHERE myfilter(Phase)',[data]);

See the working example in jsFiddle

User-defined functions and compiled statements

Custom functions:

    alasql.fn.myfn = function(a,b) {
        return a*b+1;
    }
    var res = alasql('SELECT myfn(a,b) FROM one');

Compiled statements:

    var ins = alasql.compile('INSERT INTO one VALUES (?,?)');
    ins(1,10);
    ins(2,20);

Compiled functions:

    var bigSum = alasql.compile('SELECT SUM(a) FROM one WHERE a>3', 'value');
    var res = bigSum([10]) + 10;