Tips for Using Toad for SQL Query Generation
Toad has always had Query Builder with SQL query generation functionality. This feature is more for the novice to the SQL language and allows people to build robust SQL using just drag and drop operations, check boxes, and selection drop downs.