SQL Complete v5.7 release notes

Last modified: April 9, 2025

SQL Server Support

• SQL Server 2016 Service Pack 1 (SP1) new syntax support
• SQL Server 2017 CTP2 new syntax support
• Azure SQL Data Warehouse connectivity support

Code Completion

• Highlight of matching columns in the INSERT statement
• Exclusion of database elements from the Completion List prompt
• Option to exclude schema in the ON condition of the JOIN statement
• Option to connect/disconnect when describing/pre-describing objects of the same database
• Query navigation
• CASE END pair highlighting
• Generation of the CREATE/ALTER script for server objects with the object decryption option
• Extended suggestion in the PIVOT/UNPIVOT queries
• Extended support for CTE
• Prompt and QI of variables in named transactions
• CREATE OR ALTER statement support
• Display of the estimated row count for tables

Extended Code Completion support for:

• Object prompting in:
  • CREATE OR ALTER statements
  • DROP ROUTE
  • ALTER ROUTE
  • DROP SERVICE
  • ALTER SERVICE
  • DROP RULE
  • DROP CONTRACT
  • ALTER QUEUE
  • CREATE PARTITION FUNCTION
• Syntax support for:
  • CREATE ( ALTER, DROP ) COLUMN ENCRYPTION KEY
  • ALTER EXTERNAL DATA SOURCE
  • ALTER EXTERNAL RESOURCE POOL
  • CREATE EXTERNAL TABLE AS SELECT
  • CREATE REMOTE TABLE AS SELECT
  • STRING_AGG
  • CONCAT_WS
  • TRANSLATE
  • TRIM
  • BULK INSERT and OPENROWSET ( BULK… )
  • BLOB_STORAGE option of EXTERNAL DATA SOURCE
  • DBCC CLONEDATABASE
  • ALTER ANY MASK
  • BACKUP (RESTORE) DATABASE TO URL
  • ALLOW_ENCRYPTED_VALUE_MODIFICATIONS

Other improvements

• Tab coloring
• Enabling/disabling SQL Complete from the menu
• Generate Script As from the SSMS shortcut menu