The full list of all improvements in 2017.2:
• Amazon Redshift and Microsoft Azure support: Dedicated drivers, Incremental introspection, support for Redshift functions which are absent in PostgreSQL and for specific grammar cases.
• Several databases in one PostgreSQL data source
• Evaluate expression: This will help you see data without writing a query to the console.
• Transaction Control: This replaced the Auto-commit option. There are two modes of transaction control now: Auto and Manual. This can also be defined for each query console along with the isolation level.
• Table DDL: We have divided the Data and DDL tabs when viewing a table. Actually, there are no more tabs. Now, when you open a table with a double-click, you just see the data. Where is the DDL? It can be opened by Edit Source on the toolbar.
• Integration with restore tools for PostgreSQL and MySQL
• Executing queries: Attach console action, notification when a large query is finished, auto-scroll to result-set and vice versa.
• Coding assistance: Completion for table-valued functions, NEW and OLD references are resolved in PostgreSQL triggers, support for MERGE statements, resolve for sequences.