[Show IH] Introducing Query Builder: write complex and dynamic queries without coding

If there is one way to make most sense out of your datasets, it’s through queries. We’ve recently introduced a Query Builder control in DronaHQ to effortlessly create dynamic SQL queries for your database and assign to data visualization components.

New Query Builder – superior filter powers to the database

We all know, a query builder helps to visually build SQL queries without the need of any coding.

And hence we built an UI Control “Query Builder” so the admin can implement the right filters and get the results and show the data in appropriate manner by passing the results to display controls like Table grid or List controls. This way you provide safe access to data with better data protection and problem resolving.

This is one fantastic feature that database administrators can incorporate into an admin panel and search and filter database objects dynamically, select objects and columns, save searches through a console.

This SQL query builder help you apply your instincts as a Database Administrator in a no-code way. Simply define a schema that provides the definition for the filters available. The output of the control will provide the WHERE clause that can then be passed as a variable directly to the SQL query.

For example, you could enrich your customer communication tool from your lead management database, customer support tool, and marketing automation tool to identify user behavior and attributes and plan email communications. Your data could be sitting on a MySQL database. Using the SQL query builder you can define the rules such as user web sessions, or how many days ago they were last seen on your website, or what subscription plan they are on to filter your customer data set and take action. The query builder will allow you to define the rules:

The results of which can be observed in a visual component like this table grid:

Want to query database with a visual query builder? Check out our docs →

Would love to here your questions and feedback on the query builder :)