var data = [{a:1,b:10},{a:2,b:20}]; var res = alasql('SELECT * REMOVE COLUMN b FROM ?',[data]); // returns [{a:!},{a:2}]