SQL Assistant version 12.4 released

Short introduction
SQL Assistant v12.4 contains multiple new features and enhancements, among them are two major additions - conditional formatting in data grids and actual query execution plans. The changes are described with more details in the sections below.

New major features and significant enhancements
1. Advanced spreadsheet class conditional formatting in data grids allows data visualizations in colors with a few mouse clicks. This is a game changer for all who spent much time working with data.
2. Actual query execution plans for most of the supported database systems with capturing actual run-time metrics for internal query operations. New enhancements make analyzing query plans and tuning queries easier than ever. Various techniques are used depending on the database system type to monitor its internal operations and gather performance metrics.
3. SQL Assistant add-on for 64-bit version of Visual Studio 2022.
4. Improved and more intuitive UI for setting up Context SQL Search. New graphical Code Repository browser.
5. Code entry automation - new parameters for $CURRENT(word)$ macro support more use cases.

Database management enhancements and new features
6. SQL Server - SQL Intellisense enhancements supporting features introduced in SQL Server 2022.
7. PostgreSQL - SQL Intellisense enhancements supporting features introduced in PostgreSQL 14.x and 15.x.
8. PostgreSQL - Graphical management of constraints ON DELETE features introduced in PostgreSQL 15.x.
9. Oracle - Table and index management tools now support graphical management of subpartitons.
10. DB2 - Table and index defragger.
11. Amazon Redshift - Graphical management of users, groups, and roles.
12. Amazon Redshift - Graphical management of external schemas and external tables.
13. Amazon Redshift - Graphical management of dynamic data masking policies.
14. Amazon Redshift - Graphical management of row-level security policies.
15. MariaDB - support for new UUID data type.
16. MariaDB - query execution plans for MariaDB versions 10.4 and later enriched with additional data from optimizer traces.
17. MySQL - query execution plans for MySQL versions 8.0 and later enriched with additional data from optimizer traces; table nameless aliases replaced with actual table names and more.
18. Snowflake - Improved data transfer UI allows copying data from multiple databases.
19. Snowflake - SQL Intellisense enhancements supporting many more Snowflake features.

Miscellaneous
20. UI enhancements - DB Explorer and other database navigation controls support fixed columns to keep the important context visible on screen while scrolling.
21. MySQL - better handling of expired connections for all supported connectivity drivers; automatic reconnects are more reliable.
22. Test data generator - much faster generation of sequence values when inserting data into non-empty tables; optimized checks for unique values.
23. All Performance Dashboards - now support sorting columns in data grids on column header click.
24. A number of other minor improvements and bug fixes.

Here is a link to the list of changes in the previous 12.3 maintenance release
Here is a link to the list of changes in 12.2 maintenance release
and the cumulative What's new page describing changes in all version 12.x releases.