Visual Query Builder
Writing SQL queries can be hard and queries can become so large that it's hard to keep track. Using the two way Visual Query Builder will make this easier and save you time.
- Use a graphical canvas to create or modify your query
- Treeview for query overview
- Two way: existing queries will be displayed on the canvas
- Used in SQL Editor, but also object editors like the View Editor
Drag, drop, point & click
The Visual Query Builder works using drag and drop, point & click with the following steps:
- Drag data items onto the canvas, JOINs are automatically created when foreign key constraints are available
- Select the output columns for your query
- Modify ORDER, WHERE or GROUP BY clauses using the options in the grid
- Execute the query
Complex queries made easy
The Visual Query Builder shows you the different sections of your query. Complex queries are cut up in different parts so get a clear overview.
Each UNION will add another selector to the top right of the canvas, so each query can be edited like a single query. The results are then combined into a single query with UNION clauses and options.
A sub-query will get its own tab. Both UNIONs and sub-selects are displayed in the tree view.
