JSFiddle - React, Tailwind, and code Playground

HTML

<script src="http://alasql.org/console/alasql.min.js"></script>
<p><a href="http://github.com/agershun/alasql">Alasql</a> can precompile statements. It is a kind a "prepare" in other SQL databases.</p>
<p>To compile statement use:</p>
<p>&nbsp;&nbsp;&nbsp;<b>var stmt = alasql.compile(sql)</b></p>
<p>Then run the statement:</p>
<p>&nbsp;&nbsp;&nbsp;<b>stmt([parameters array], callback)</b></p>

<p>Sum of numbers > 2 from [1,2,3,4,5] is </p>
<span id="res"></span>

JavaScript

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])

document.getElementById("res").textContent = res;