...
1 - Ribbon Bar
Functions to Save, Exit, Run, and Data Model Optimizations exist here.
Save - Save the Query.
Exit - Close the Query and return to the Main Menu.
Run Query - Executes the Query against the database and displays the results in the Query Grid.
Data Model Optimize - Filters out unused tables from the Query. Only used for very large Data Models.
Data Model Save - Saves the optimized Data Model to the database.
Data Model Restore - Reverts the Data Model to its original design.
2 - Entities
This section lists all of the different tables contained within your Data Model. This panel is used as a visual representation of all entities (tables) and their attributes (columns), which we can use to build queries. It can be used to add entity attributes to a Columns Panel (and they will be displayed in the result) or to a Conditions Panel (in order to actually set the query conditions).
3 - Columns
The section lists all of the different columns you have selected to be displayed in your query results. You have a list of lines, each of them represents a column in the query results (in the Results Panel). Every line consists of Expression, which is an attribute, a Title, which serves as a column title in the Results Panel, and buttons – for sorting (on the left), aggregating and deleting (on the right).
...