EMS SQL Query 2011 for SQL Server full changelog

Implemented support for Azure, SQL Server 2017, MySQL Server 8, PostgreSQL 12 and Firebird 3.0.
PostgreSQL. Added support for materialized views.
Oracle. Results for NCHAR columns are now displayed correctly.
Connection via SSH tunnel now supports passphrase.
The error occured on simultaneous registering of several databases. Fixed now.
The error was duplicated on switching between editor tabs. Fixed now.
PostgreSQL. WITH queries are now processed correctly.
Oracle. Connection with TNS_ADMIN environment variable is now supported.
Other fixes and improvements.

· Added the possibility to parse subqueries in the JOIN statement.
Query Builder:
· Added the automatic display of the JOIN statement for tables with foreign keys (DB2, InterBase/Firebird, MySQL, Oracle).
· Added the possibility to use aggregate functions in the CASE statement.
· Added the possibility to execute only the selected part of a query in Query Editor.

· When parsing a query, which contained the name of a table starting with an underscore, AV error occurred. Fixed now.
· In SQL Query for DB2 it was not possible to execute a query after error occurrence. Fixed now.

SQL Query for PostgreSQL:
· It was not possible to execute query when using a cast operator. Fixed now.
· When setting a button bar, the button headers were missing. Fixed now.

· SQL Query for MySQL. When parsing the UPDATE query with a subquery in the WHERE clause, an error occurred. Fixed now.
SQL Query for PostgreSQL:
· It was not possible to execute query when using a cast operator. Fixed now.
· When setting