When comparing QueryPie vs AQT, the Slant community recommends QueryPie for most people. In the question“What are the best SQL Clients for Windows?” QueryPie is ranked 3rd while AQT is ranked 24th. The most important reason people chose QueryPie is:
The default color is dark and comfortable for the eyes.
Specs
Ranked in these QuestionsQuestion Ranking
Pros
Pro Clean and pretty UI/UX
The default color is dark and comfortable for the eyes.
Pro Multiple Query Tabs!
The multi-tab and multi-SQL-runs are great. It's always good to be able to compare results in one window instead of having to go through and re-run stuff.
Pro Fast Auto-complete
Pro Multiple Databases
They only support 2 at the moment (MySQL and MariaDB) but their social site says they'll be updating with more DBMSes in the near future which is pretty nice because I hate learning new GUIs~
Pro Cross-Platform
Not sure about Linux but it works on Windows and Mac just fine!
Pro Free!
Pro Intuitive visual data explorer
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.
Pro Easy scripting language for repeatable processes
Pro Point-and-click data loader
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.
Pro Visual query builder
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.
Cons
Con Requires creating an account
Requiring an account is rare on SQL IDEs...
Con Still in beta
Con No visualization
