Nuget link: https://www.nuget.org/packages/Bharat.DevExtreme.Helpers.DataSource/
var Builder = new WhereClauseBuilder();
var json = "[\"CustomerID\",\"=\",\"ALFKI\"]";
var jarray = JArray.Parse(json);
var 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 ISQLColumnProvider if you are using table aliases you can customize there.