JSFiddle - React, Tailwind, and code Playground

HTML

<script src="https://cdn.jsdelivr.net/npm/alasql@2"></script>
<xmp id="result"></xmp>

JavaScript

alasql("CREATE TABLE cities (city string, population number)");


alasql("INSERT INTO cities VALUES ('Rome',2863223), ('Paris',2249975), ('Berlin',3517424), ('Madrid',3041579)");


var res = alasql("SELECT * FROM cities WHERE population < 3500000 ORDER BY population DESC");


showResult(res)






function showResult(x){
    document.getElementById('result').textContent = JSON.stringify(x,  null, '\t');
}