Visual Query Builder

Visual Query Builder is a tool inside DbSchema which is opening inside layouts. The tool is saved inside the project file and can be reopen 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. Alternative you can start an empty editor and drag & drop a table from the layout.
Access Query Builder

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 project file.

Add further tables to layout by clicking the small arrow icon near column. Clicking the label on the foreign key line you can switch to different join types: INNER JOIN, LEFT JOIN, EXISTS.

Open FK

Choose columns to select

Choose the columns to select by ticking the column checkboxes

Select Column

Filter the data

Data can be filtered by right-click any of the columns and choosing the 'Filter' option

Filter

Use Group By

The query can make use of the GROUP BY cause by selecting the toggle button in the query builder menu. Than you can make use of aggregate functions by right-clicking any of the columns and choose Aggregate: MIN, MAX, SUM, AVG....

Group By

Save Result to File

Similar with the SQL Editor, the result can be saved to file from the Result pane.