Ported from DevExtreme.Helpers.DataSource written in C#.
WhereClauseBuilder builder = new WhereClauseBuilder();
String json = "[\"CustomerID\",\"=\",\"ALFKI\"]";
JsonArray jArray = (JsonArray) (new JsonParser().parse(json));
String sqlWhereClause = builder.buildFor(jArray);
Outputs:
CustomerID = "ALFKI"
In sql you can write
Exec('Select * from customers where ' + @sqlWhereClause);
There is an overloaded version of WhereClauseBuilder
you can provide your own implentation SQLColumnProvider
if you are using table aliases you can customize there.