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.