Advanced Query Tool

I love the user interface an ease of getting started building queries or using existing sql. The company is very responsive and even incorporated one of suggestions into the product.

I love the user interface and ease of which you can build queries or run it off existing sql. The company is very responsive to questions / input. They even incorporated one of mine! Great tool.

Connects to many databases, same interface for all. Have used since 2001. The data load features are especially nice. This is my Swiss Knife for most things database.

Advanced Query Tool or AQT is a robust SQL database tool that supports any database accessible through ODBC with many capabilities to ease data analysis, write queries, load and export data. Some of the key features include 1) a point and click data loader that generates your create table statement when creating a new table and includes the ability to add column expressions to alter/clean your source data during the load, 2) a visual data explorer to view your sql result set and easily total, sort, format, and group it(grouping is done by dragging columns to the header and groups can easily be collapsed/expanded and show column subtotals);You can also freeze columns on the left to for easy viewing of wide result sets, copy any row or rows to excel or other tool including column headings and get totals by highlighting adjacent columns and 3) a robust visual query builder that has the ability to easily create sql including complex sub-queries, supports with clauses and can save your table relationships for re-use. An advanced version also includes a base set of database administration tools.