dbForge SQL Complete Standard full changelog

Resolved issues with queries used to retrieve descriptions of tables, indexes, and constraints (#221795)
Improved filtering of string literal suggestions in the completion list (#222546)

Fixed a "Retrieving metadata" freeze when opening a SQL document (#221224)
Fixed a critical error that caused SSMS to terminate when re-executing a query in a document (#222420, #222538, #222519, #222298, #222470)

Fixed an issue where column values for the INSERT statement were incorrectly assembled when they were nested SELECT queries (#165574)
Fixed an issue where the Code Completion window closed when the entered text matched a shortcut snippet (#170898)
Fixed the display of data in the Data Viewer (#167482)
Fixed the filtering of time zones in the completion list (#170893)
Fixed the behavior of the Include default schema in object names option in JOIN condition suggestions (#214503)

User-reported bug fixes:
Fixed an issue that occurred when a connection to Azure Blob Storage was present in Object Explorer (#190663)
Fixed column alias suggestions in INSERT ... SELECT expressions (#191837)

Connectivity:
Added support for dedicated and serverless SQL pools in Azure Synapse Analytics
T-SQL Analyzer:
Expanded the set of rules
User-reported bug fixes:
Resolved an issue with reading foreign keys across schemas, enabling correct suggestions in Code Lookup (CL) (#176246)
Restored the assignment of aliases to columns in SELECT statements generated using dbForge SQL Complete (#193439)
Corrected the behavior of the Commit Selection on Whitespace option — pressing the spacebar no longer triggers selection in the Column Picker (#178655)
Improved the text replacement logic when inserting items for quoted unfinished identifiers (#169524)
Fixed an issue where the tab color was lost when switching users (#164931)
Fixed a hang that occurred after pressing Execute. It is now possible to set focus in the result grid of the Registered Server dialog. (#200747)
Added support for the CREATE USER FOR EXTERNAL PROVIDER syntax in code completion and SQL formatting (#199473)
Fixed an issue where file path separators in paths to script files executed by sqlcmd were incorrectly surrounded by spaces during SQL document formatting (#203956)
Resolved code completion glitches that occurred when typing quickly (#165191, #166191, #203202, #200132)
Fixed freeze in SQL Server Management Studio when opening the Database Explorer menu immediately after startup with the Devart extensions installed (#176935, #166428)

User-reported bug fixes:
Fixed the hierarchy update issue when adding a snippet (#177915)
Fixed an issue with the cursor movement after inserting a snippet (#167836)
Removed the error message with code 15003 from the Output window (#164962)
Fixed an issue where renaming an alias caused the process to be unexpectedly canceled (#171108)
Fixed an issue where an error window frequently appeared when a physical file included in the project was missing (#170283)
Fixed a rare issue that occurred when selecting data in the data grid (#165935, #166203)
Fixed a rare issue that occurred when using the Insert semicolons command (#178796)
Resolved a rare issue with inserting items from the completion list (#164582, #166081, #171328, #185579, #189328, #189431, #189638)
Fixed an issue where suggestions were missing in the document when connected with a login that had a default database other than the master database (#179781)
Optimized the retrieval of synonyms for document suggestions (#167972)

Fixed an issue where the editor lost selection after inserting a snippet (D164311, D165305)
Fixed an issue with database selection when opening a document by selecting the Script Object as CREATE/ALTER option (D127840)
Fixed an issue that occurred when describing server declarations (D164811)
Fixed an issue that occurred during quick text editing with tooltips displayed (D164461, D164486, D165122, D165669, D165644, D165738, D165742, D165242, D165886, D165761, D166965, D167215, D167082, D166869, D165977, D167773)
Fixed a connection retrieval issue in earlier versions of SSMS (D164434, D165441, D165973, D165985, D166187, D166080, D166181)
Improved the behavior of the CTRL K+X shortcut so that snippets now only open in comments (D165944)
Updated the format for DATE and TIME literals in Snippet Manager to comply with the ISO 8601 standard (D164767)
Added the Generate Script As BULK INSERT command to the Results window of Query Editor (D164594)
Fixed an issue that occurred after closing the document in Query Editor (D165158)
Improved the Copy Data As > HTML functionality by resolving issues with data extraction from SSMS results and adding HTML styles for the Copy Data As > HTML > To Clipboard format (D164141, D166268)
Fixed the "Index and length must refer to a location within the string" error (D164540)
Implemented handling for system errors that occur during file system operations (D164284)
Improved the display of object lists in text tooltips (D164659, D164686, D164700, D166219, D167566, D167865, D167927, D167930, D168422, D168653)
Fixed an issue that occurred when working with projects (D165200, D165588, D164891, D165715, D167304)

Improvements:
Introduced the Enterprise Edition of SQL Complete with T-SQL Code Analyzer
Added integration support for Microsoft Visual Studio 2022
Added integration support for Microsoft SQL Server Management Studio 20.2
Added support for non-aggregated columns in GROUP BY statements
Added support for viewing the MSDescription property for databases
Added support for the PERSISTENT_LOG_BUFFER construct in CREATE DATABASE statements
Added support for the RSA_OAEP algorithm in CREATE COLUMN ENCRYPTION KEY statements
Added support for the COLUMN MASTER KEY server object
Added support for T-SQL graph functions: EDGE_ID_FROM_PARTS, GRAPH_ID_FROM_EDGE_ID, GRAPH_ID_FROM_NODE_ID, NODE_ID_FROM_PARTS, OBJECT_ID_FROM_EDGE_ID, and OBJECT_ID_FROM_NODE_ID
Added support for the TERTIARY_WEIGHTS function
Extended support for the AVAILABILITY GROUP constructs
Redesigned the SQL Query history toolbar with an updated date range selection and a new Clear button
Added the ability to save user-defined column layouts in Query History
Added CLI automation for Find Invalid Objects
Added Save Command Line for Find Invalid Objects
Added Save Command Line for SQL Formatter Wizard
Support for Implicit Procedure Execution
User-reported bug fixes:
Resolved issues that arose when selecting the case for automatic formatting of identifiers (T252989, T257652, T269036, T270192, T276488, T270192, D76531, D125424, p162685, T307930, T309179, u33847234, p188493, D89127)
Resolved the issue where invoking FORMAT SELECTION caused the query to become invalid (D123102)
Fixed the issue where the Convert EXEC to SQL functionality failed to function on queries without named parameters (D135198)
Fixed the behavior of CTE aliases in subqueries (D135239)
Fixed the behavior of object hints in the FROM clause within table-valued functions (D143009)
Resolved the issue where formatting scripts containing regions caused the query to become invalid (D145046)
Added the capability to set the QUOTED_IDENTIFIER and ANSI_NULL

Code Completion improvements:
Added support for the GENERATE_SERIES and OPENQUERY relational operators
Added support for the following functions: LEFT_SHIFT, RIGHT_SHIFT, BIT_COUNT, GET_BIT, and SET_BIT
Added support for the APPROX_PERCENTILE_CONT and APPROX_PERCENTILE_DISC aggregate functions
Added support for the DATETRUNC function
User-reported and internal bug fixes:
Improved memory utilization during the processing of suggestions (D107724)
Fixed issues with SQL document closing or losing focus (D109291, D109290)
Resolved an error that occurred when analyzing invalid objects (D119419)
Fixed an issue with generating CRUD operations for tables (D113761, D116787)
Resolved an issue where Completion List suggestions were not working properly after selecting a different Azure database in the SQL document connection field (D119532)
Optimized the search functionality for the Go To Definition feature (D119530)
Fixed handling of user literals when editing a snippet (D119126)