When comparing SQL Workbench/J vs QueryPie, the Slant community recommends QueryPie for most people. In the question“What are the best GUI tools for PostgreSQL on Windows?” QueryPie is ranked 7th while SQL Workbench/J is ranked 10th.
Ranked in these QuestionsQuestion Ranking
Pro Works with almost any SQL database
Can work with any database with a jdbc driver.
Pro Can edit data in table mode.
Easy to make changes when viewing data.
Pro Allows you to edit changes before they are executed.
Any changes to the database generate SQL statements that you can review and edit before running.
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 Clean and pretty UI/UX
The default color is dark and comfortable for the eyes.
Not sure about Linux but it works on Windows and Mac just fine!