const wherefilter = require( 'node-where-filter' );
var exprTree = wherefilter.makeTree( '(name~Jack || name="Mike A") && age>10 && alias<10', { alias: 'other name' } );
console.log( exprTree );
var dataTable = [
{ name: 'Jack A', age: 20, 'other name': 6 },
{ name: 'Jack B', age: 29, 'other name': 11 },
{ name: 'Mike A', age: 20, 'other name': 6 },
{ name: 'Jack', age: 9 , 'other name': 6 },
];
console.log( dataTable.filter( wherefilter.where( exprTree ) ) );
console.log( wherefilter.whereSQL( exprTree ) );