AQT vs SQL Notebook
When comparing AQT vs SQL Notebook, the Slant community recommends SQL Notebook for most people. In the question“What are the best SQL Clients for Windows?” SQL Notebook is ranked 19th while AQT is ranked 24th.
Specs
Ranked in these QuestionsQuestion Ranking
Pros
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.
Pro Portable version
Pro Cross database queries
Any combination of data sources can be used together in the same SQL query, including cross-file, cross-database, and cross-server queries.
Pro Multi database
Microsoft SQL Server, PostgreSQL, and MySQL.
Pro Free
Free and open source.
Cons
Con Some queries do not work
Did some tests with PostgreSQL 9.5 and some complicated queries did not work.
