JSFiddle - React, Tailwind, and code Playground
HTML
<script src="https://rawgit.com/agershun/alasql/develop/dist/alasql.js"></script>
<xmp id="output"></xmp>
JavaScript
var data = [
{a:3},
{a:4},
{a:5}
];
print(alasql('SELECT a%2 as isOdd, count(*) as `count` FROM ? GROUP BY a%2',[data]));
function print(x){
document.getElementById('output').textContent += JSON.stringify(x, null, '\t')+"\n";
}
print('AlaSQL v'+alasql.version)