Visual Query Builder
Introduction
If you need to compose database queries visually, without having to be an SQL expert, the Visual Query Builder is the right tool for you. The Visual Query Builder will open inside layouts, will be saved inside the model file, and can be reopened from the Data Tools menu.
How to Start the Query Editor
The easiest way to start the Query Editor is by clicking the table header. Alternatively, start an empty editor and drag & drop a table from the layout.
Join further tables to the query
You may join further tables to the query using foreign keys or virtual foreign keys. Virtual foreign keys can be created by column drag & drop in the layout and will be saved to the model file.
Add further tables to the layout by clicking the small arrow icon near columns. Clicking the label on the foreign key line you can switch to different join types: INNER JOIN, LEFT JOIN, EXISTS.
Choose columns to select
Choose the columns to select by ticking the column checkboxes.
Filter the data
Data can be filtered by right-clicking any of the columns and choosing the 'Filter' option.
Use Group By
The query can make use of the GROUP BY clause by selecting the toggle button in the query builder menu. Then you can make use of aggregate functions by right-clicking any of the columns and choose Aggregate: MIN, MAX, SUM, AVG...
Save Result to File
Similar to the SQL Editor, the result from the Result Pane can be saved to file.