User defined functions

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

alasql.fn.double=function(x){returnx*2};alasql.fn.sum10=function(x,y){returnx+y*10;}alasql('SELECT a, double(a) AS b, sum10(a,b) FROM test1');

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

CREATEFUNCTIONcubicAS``function(x) { return x*x*x; }``;

Aggregators

// How to implement the SUM() aggregatoralasql.aggr.MYAGGR=function(value,accumulator,stage){if(stage==1){// first call of aggregator - for first linevarnewAccumulator=value;returnnewAccumulator;}elseif(stage==2){// for every line in the groupaccumulator=accumulator+value;returnaccumulator;}elseif(stage==3){// Post production - please nota that value Will be undefinedreturnaccumulator;}}

Create aggretating functions

CREATE (AGGREATE|AGGREGATOR) MyAggrAS``function(value, accumulator, stage) { ... }``;

CustomFROM function

alasql.from.DB = function(dbtype, opts, cb, idx, query) {var res = [];        async_read_data_from_mysql_function(dbtype, opts.dbname, opts.tablename, function(data) {res = data;if(cb){res = cb(res, idx, query);}};return null;};function async_read_data_from_mysql_function(dbtype, dbname, tablename, cb) {    // put your code here   cb(read_data);}

SELECT*FROM DB("mysql",{dbname:"one", tablename:"two"})

alasql('SELECT * INTO DB("mysql",{dbname:"one", tablename:"two"}) FROM ?',[data]);