Query Builder parse sql

Webix JS
#1

Allows to export rules as a SQL WHERE statement?

#2

The output JSON is different from SQL and specified in details ofgetValue method.

#3

We have it in plans

#4

@eric such solution for SQL is availiable for now https://docs.webix.com/querybuilder__convert_to_sql.html

#5

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?

#6

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.