JSFiddle - React, Tailwind, and code Playground

HTML

<script src="https://rawgit.com/agershun/alasql/develop/dist/alasql.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.8.0/xlsx.full.min.js"></script>
<xmp id="output"></xmp>

JavaScript

print('Fill data')
var sql = "CREATE TABLE [Table] (Field1 string, Field2 integer, Field3 string);"
					+"INSERT INTO [Table] VALUES ('new',2,'aaa'),('new',1,'bbb');"
var res = alasql(sql);
	

print('SELECT with params passed to sub query in WHERE section works')
print(alasql.exec("SELECT * FROM [Table] WHERE ( [Field2] <= ( SELECT [Field2] FROM [Table] WHERE [Field3] = ? ))", ['bbb']))  


print('UPDATE with params passed to sub query in WHERE section does not work')
print(alasql.exec("UPDATE [Table] SET [Field1] = 'New21' WHERE ( [Field2] <= ( SELECT [Field2] FROM [Table] WHERE [Field3] = ? ))", ['bbb']))  



print('Another notation for params also not working')
print(alasql.exec("UPDATE [Table] SET [Field1] = 'New21' WHERE ( [Field2] <= ( SELECT [Field2] FROM [Table] WHERE [Field3] = $0 ))", ['bbb']))  






function print(x){
    document.getElementById('output').textContent += JSON.stringify(x,  null, '\t')+"\n";
}
print('AlaSQL v'+alasql.version)