When comparing SQL Notebook vs SQL Workbench/J, the Slant community recommends SQL Workbench/J for most people. In the question“What are the best SQL Clients for Windows?” SQL Workbench/J is ranked 12th while SQL Notebook is ranked 19th. The most important reason people chose SQL Workbench/J is:
Any changes to the database generate SQL statements that you can review and edit before running.
Specs
Ranked in these QuestionsQuestion Ranking
Pros
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.
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 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.
Cons
Con Some queries do not work
Did some tests with PostgreSQL 9.5 and some complicated queries did not work.