Compile

Presompile SQL statements

alasql.compile() lets you precompile statements. It is a kind a "prepare" in other SQL databases.

To compile statement use:

   var stmt = alasql.compile(sql [, dbName])

Then run the statement:

   stmt([parameters array] [, callback])

Compiled statement examples:

    var bigSum = alasql.compile('SELECT SUM(a) FROM one WHERE a>?', 'myDBname'); // no DBname needed
    var foo = bigSum([10]) ;

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

Here is the example how to calculate sum of numbers > 2 from [1,2,3,4,5]:

    var data = [{a:1},{a:2},{a:3},{a:4},{a:5}];

    // Compile
    var mysum = alasql.compile("SELECT VALUE SUM(a) FROM ? WHERE a > 2");

    // Run
    var res = mysum([data])

Try this example in jsFiddle