Visual Query Builder provides a visual interface for building complex SQL queries in the Read from DB stage. To work with Visual Query Builder, you need basic knowledge of SQL concepts.
To access Visual Query Builder, click the Build SQL button in Read from DB.
The query builder main window is divided into these parts:
- The Query Building Area is the main area where the visual representation of query will be displayed. This area allows you to define source database objects, define links between them and configure properties of tables and links.
- The Columns Pane is located below the query building area. It is used to perform all necessary operations with query output columns and expressions. Here you can define field aliases, sorting and grouping, and define criteria.
- The page control above the query building area will allow you to switch between the main query and sub-queries.