Visual Query Builder is a DbSchema tool for building and executing SQL queries. The queries can use multiple tables with inner, outer or exists joins, group by, order by, etc.
We join a second table by clicking the foreign key icon. We may change the join type by clicking the foreign key line between tables. If you miss foreign keys, you can create virtual foreign keys in the layout. They will be persisted to the project file.
By double-clicking the table header we may edit the table alias used in the queries.
The composed query is always visible on the left, in the SQL Preview frame.
Execute the query directly in the query builder.