Allows to export rules as a SQL WHERE statement?
We have it in plans
@eric such solution for SQL is availiable for now https://docs.webix.com/querybuilder__convert_to_sql.html
This is great, but is there a way to use the Query Builder to build the SELECT part of a query and not only the WHERE part?
I understand the Query Builder is more for filtering data, but I am wondering about possibilities.
For example, if we have “SELECT SUM(spend) FROM suppliers WHERE supplier_code = ‘A001’”, the Query Builder can return the WHERE part, but how about the “SELECT SUM(spend)” part?
Hi, @Chrisiaan !
You are right, only the WHERE part can be generated by Query Builder. And then you can add any necessary SELECT part to it.