It has lot of user-friendly options,where in easily one can edit the data with edit option and while writing the query it shows some smart options where in column name pops-up, which makes the work easier,and there is option to retrieve your old queries.

I've been using AQT for over 15 years and found it to be the best tool for my role as a data warehouse architect and data analyst in multiple database enviroments. There are many capabilities for point and click data analysis, queries creation, loading and exporting data. My favorites 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, 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 and 4) built in scripting to easily automate repetitive processes like regression testing. An advanced version also includes a base set of database administration tools.

The user interface makes it easy and quick to see all the most relevant information. I can filter the lists of tables/views/schemas, quickly see indexes, keys, constraints, columns, and data without wasting time. It performs all the tasks I need day to day without a lot of hassle and is very configurable. The author is quick to respond to and correct issues.