...
Wildcard (*) can be used when filtering. For example by typing “*(>” all the lookup fields of the current SObject are displayed. When clicking on a green arrow of a lookup fields you can navigate to the related SObject.
...
Functions:
By defining a “Function” it is possible to create an aggregate query. For example you can sum a number or find some max values. However, you need to define all fields as function fields or none:
...
If one field is a grouped field, which means the GroupBy function is selected for this field, the Group Condition (Having) becomes editable.
Copy Merge Fields
A very powerful feature of the query builder which makes creating Word templates very easy and efficient is to be able to copy & paster merge fields directly from the query builder into your Word document.
...