Query Reporter - The Query Builder

Screenshot

The Query Builder can be used from within the SQL editor to create or modify the select statement of your report. Simply drag tables and views from the Object Browser on the left, and drop them into the work area on the right. If foreign key constraints exist between the tables, you are automatically asked if they should be used for join conditions.

The columns can be selected for the field list, where clause and order by clause in the bottom section of the Query Builder.

Various preferences affect the layout of the generated select statement, such as alignment, margin, case, and so on.

back