dbForge Query Builder for SQL Server Revision History

2026.1.77 25-Jun-2026

User-reported bug fixes

Fixed a false-positive syntax error triggered by Transact-SQL expressions referencing objects named window
Added the MFA Application ID to the settings export
Resolved clipboard data corruption when copying HTML data with duplicate column names

2026.1.39 15-May-2026

User-reported bug fixes

Several minor bugs are fixed

2026.1.31 11-May-2026

AI Assistant

Improved AI Assistant by adding support for database index metadata

Text Editor

Added the Enclose identifiers in quotes feature to the SQL Editor
Added indexed column icons in Quick Info

Improvements

Added the ability to pin document tabs
Added the ability to restore document tab order

User-reported bug fixes

Fixed automatic document saving to include additional information such as the connection (#236503)
Fixed an issue where the document database was lost for recovered documents
Fixed the behavior of the "SQL Look In" option in the Find and Replace control
Fixed MFA authentication when connecting under different user accounts
Fixed an error in the data editor that occurred when executing a modified query before the previous query had finished fetching data
Updated the installation wizard to not display the "Successful Install" page during dbForge product updates
Fixed the auto-hint behavior for server selection on the Connection form
Improved saving of window layouts and restoration of window positions after restarting the Studio

2025.3.149 25-Mar-26

User-reported bug fixes

Fixed an issue with query execution in Query Builder that occurred after values were edited

2025.3.107 12-Feb-26

User-reported bug fixes

Several minor bugs are fixed

2025.3.93 29-Jan-26

User-reported bug fixes

Added support for the FORCESEEK table hint in FROM clauses for the Text Editor

2025.3.61 24-Dec-25

Text Editor Improvements

Added scroll bar annotations
Added an option to automatically surround selections
Added camelCase formatting for identifiers

User-reported bug fixes

Fixed an issue where Query Builder regenerated an invalid script when a column had an alias (#223374)
Fixed an error that occurred in Query Builder when working with GROUP BY
Fixed an issue where floating-point values lost precision when copied to Excel

2025.2.138 20-Nov-25

User-reported bug fixes

Improved the display of multiline SELECT list items in the query builder grid

2025.2.109 31-Oct-25

User-reported bug fixes

Resolved an issue with displaying the tooltip for a document bookmark, where the tooltip window overlapped the document bookmark

2025.2.91 23-Oct-25

User-reported bug fixes

Fixed an exception caused by empty values in the parameter input form in SQL Document
Fixed an issue with clearing the DataViewer
Resolved an issue with dragging objects from Database Explorer to the diagram

2025.2.37 23-Sep-25

AI Assistant

Introduced automatic error submission from the Error List to AI chat for detailed explanations and suggested fixes
Added a Web Search option in the AI Assistant chat, allowing searches across Devart documentation, website, and blog

Connectivity

Enhanced authentication capabilities for SQL Server when using Entra ID
Added support for Microsoft Fabric

Improvements

Improved encryption capabilities
Added tooltips to the SQL document tab, showing connection and database names, document owner, full file path, and server version
Introduced the ability to customize the position where new document tabs open
Added Alt+Up and Alt+Down shortcuts to move selected lines up or down in the SQL document
Added the Ctrl+Shift+A shortcut to select the entire statement in the SQL document, including all related keywords, operators, and values
Added options to qualify column names with table or alias names
Added full support for the OPENROWSET function in Syntax Check

User-reported bug fixes

Fixed an issue with aliases(#207241, #206537)

2025.1.230 21-Aug-25

User-reported bug fixes

Fixed an issue that caused the suggestion list to close when typing numbers

2025.1.186 21-Jul-25

User-reported bug fixes

Fixed an issue with long file names
Removed opening the connection on the main thread when opening the parameter input form
Fixed an issue with the automatic display of Data Editor: when the Activate Data Editor after query execution option is enabled, Data Editor now opens automatically after a query runs, even if no data is returned

2025.1.134 23-Jun-25

User-reported bug fixes

Fixed column alias suggestions in INSERT ... SELECT expressions

2025.1.124 16-Jun-25

AI Assistant is added

Context-aware query generation
Conversion of natural language to SQL
Query optimization
SQL explanations
SQL troubleshooting
Error analysis and recommendations
AI chat
Integration with the dbForge tools

Connectivity

Added support for dedicated and serverless SQL pools in Azure Synapse Analytics

Improvements

Updated color palettes for the Light and Dark skins
Refined font rendering and the coloring of syntax errors
Added Brief View to the Start Page to switch between displaying full paths to recent files and a more compact list

User-reported bug fixes

Several minor bugs are fixed

7.1.63 14-May-25

User-reported bug fixes

Several minor bugs are fixed

7.1.45 18-Apr-25

User-reported bug fixes

Fixed an error with reading the database list when connecting to the server

7.1.37 07-Apr-25

Improvements

Added support for SQL Server 2025
Supported compatibility with Windows Server 2025

User-reported bug fixes

Several minor bugs are fixed

7.0.362 07-Mar-25

User-reported bug fixes

Improved the generation of column names for SELECT queries
Added support for data filtering in Data Editor for SELECT queries with an ORDER BY clause
Optimized the execution of the Export to CSV command in the Query History window

7.0.249 14-Nov-24

User-reported bug fixes

Modified snippet sorting in the code completion list (#164982)

7.0.210 18-Oct-24

User-reported bug fixes

Several minor bugs are fixed

7.0.158 05-Sep-24

Connectivity

Renamed the Azure Active Directory authentication type to Microsoft Entra ID
Added support for ApsaraDB

SQL Query History

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

Documents

Added options to rearrange tab opening order
Added new options in Tabs and Windows: Tab layout, Show tabs in multiple rows, and Close tabs with middle-click
Added a new shortcut CTRL+SHIFT+/ that comments selected pieces of code

Data Editor

Added an option to set a cell value to a unique identifier from the shortcut menu

User-reported bug fixes

Restored the Active format profile menu group of options in the context menu of the SQL document (#152917)
Fixed the tooltip in the Query Builder by removing objects from other databases (#134219)
Fixed an error that occurred when copying and pasting subqueries in Query Builder (#144556)
Fixed the display of operators in the column selection window of the Query Builder (#97682)

4.2.35 12-Apr-24

User-reported bug fixes

Several user reported minor bugs are fixed

4.2.33 28-Dec-23

User reported bug fixes

Several user reported minor bugs are fixed

4.2.29 12-Jul-23

User reported bug fixes

Fixed an error that occurred when the SQL document was closed while processing the parameter list for functions
Expanded the list of conditions in the Filter Editor for columns of type int in the Data Editor
Resolved a freezing issue that occurred when editing values in large tables in Data Editor

4.2.25 12-May-23

User reported bug fixes

Several user reported minor bugs are fixed

4.2.22 30-Dec-22

New features and improvements

Support for macOS & Linux via CrossOver
Improved the metadata reading behavior - the VIEW DATABASE STATE privilege is no longer required (p135909, T308355, #71423, #98539, #103313)

User reported bug fixes

Fixed a bug that occurred when importing data (#99244, #99762)
Fixed the disappearance of the DESC keyword (#94579, #102637)

4.2.16 12-Sep-22

New features and improvements

Connectivity support for SQL Server 2022 CTP 2.1

4.2.10 20-Jul-22

User reported bug fixes

Fixed the behavior of shortcuts in SQL Editor

4.2.5 17-Jun-22

New features and improvements

Added support for new functions in the Completion List, Quick Info, and Parameter Information: GREATEST, LEAST, CURRENT_TIMEZONE, CURRENT_TIMEZONE_ID
Added support for the FORMATFILE_DATA_SOURCE parameter for bulk_options in the OPENROWSET function

User-reported bug fixes

Fixed an issue with the search and replacement of values in Data Editor (#76642)

4.1.5 21-Dec-21

New features and improvements

Improved the behavior of data sorting in Data Editor
Added the ability to resize the search text field
Added a warning when trying to save read-only files with the applied changes
Improved the display of table relationships on the Query Builder diagram

User-reported bug fixes

Incorrect change of a query when updating it in Query Builder
Fixed the behavior of pasting from clipboard when working with Query Builder

4.0.16 20-Oct-21

User reported bug fixes

The application fails with a critical error when trying to create diagram objects after installing the KB5006670, KB5006672 or KB5006674 Windows update

4.0.14 10-Sep-21

New features and improvements

Ability to simultaneously connect with different ApplicationIDs to Azure SQL Server

User-reported bug fixes

Incorrect change of a query when updating it in Query Builder
Error with canceling the operation in Data Editor
Improved behavior with the active Paste As New Records command in Data Editor
Improved behavior of active control of changing the current database when executing the query in SQL Document
Coloring of cells with the NULL values in Data Editor
Error when completing the procedure with parameters in Data Editor
Error when executing a query with parameters of the Date type in Paginal Mode in Data Editor
Error with specifying an incorrect value in the Filter window in Data Editor
Processing of the Ctrl+A, Ctrl+C shortcuts in Data Viewer

4.0.12 26-Aug-21

New features and improvements

Data Reports
Master-Detail Browser
Pivot Tables

3.16.45 16-Jun-21

New features and improvements

New formatting profiles
Options search
Data export to CSV

3.15.78 08-Oct-19

User reported bug fixes

Several user reported bugs are fixed

3.15.55 27-Jun-19

User reported bug fixes

Several user reported bugs are fixed

3.15.42 10-May-19

User reported bug fixes

Problem with query opening is fixed (T277169)
Minor user reported bugs are fixed

3.15.30 20-Feb-19

New features and improvements

Support for the Active Directory - Universal with MFA authentication

User reported bug fixes

Several user reported bugs are fixed

3.14.29 21-Dec-18

New features and improvements

Connectivity support for SQL Server 2019
Product now integrates into SSMS v18

User reported bug fixes

Problem with activation is fixed (T240520)

3.12.56 19-Jul-18

User reported bug fixes

Text parsing is fixed (T256623)
Null Reference Exception is fixed (T253164)
User reported bug is fixed (T260608)

3.12.39 30-Aug-17

SQL Server 2016 Service Pack 1 (SP1) new syntax support
SQL Server 2017 new syntax support
Azure SQL Data Warehouse support
New query execution history feature saves information about SQL statement you run
Each document uses its own connection now

3.11.34 20-Apr-17

General improvements

Compliance with the Federal Information Processing Standard (FIPS)
Trial product activation implemented
Greatly improved visual style of the application with high DPI support
Connection to Microsoft Azure SQL Database by using identities in Azure Active Directory

Query Profiler

Live query statistics
Wait Stats tab
Saving/Opening execution plan files
Table I/O
Highlighting potentially resource-intensive statements
Displaying clustered columnstore indexes in execution plan

Data Export/Import

Dramatically improved data import performance
Export/import of JSON data
Redesigned export/import of XML data
Preview of the generated UPDATE script in the wizard
Detection of column types when importing data from the Excel format
Execution of SET IDENTITY_INSERT ON when the Repopulate option is enabled during data import

3.10.14 17-Aug-16

SQL Server 2016 support
Greatly improved suggestion performance
Objects suggestions in CROSS/OUTER APPLY statement
Several new formatter options and profiles
Data type information to the column header in Data Grid added
Data Grid now supports Generate Script As feature
Generate Script As now available for multiple objects in Database Explorer
Installation wizard redesigned
User reported bugs are fixed (T158724, T161047, T161500)

3.9.165 3-Jun-15

User reported bugs fixed
Performance and stability improvements

3.9.163 13-Nov-14

SQL Editing and Execution

Query execution pane
Easy way to hide results
Updated Find&Replace feature in documents and files

Data Editor

Data Viewer, LOB Editor, and Redirect Data to Output are combined in a single control
Zooming font size in Data Viewer and Editor Window

Database Explorer

Displaying the objects number

Query Profiler

Diagram printing options for a Query Profiler Plan Diagram

Data Export

Updated Export wizard

User Interface

Support of multiple monitors
New skins
Updated Start Page

Other Features and Improvements

Improved application performance
Windows 10 support

3.8.147 26-Jun-14

A problem related to opening existing queries is fixed (T107349)

3.8.140 20-Jun-14

The list of the new features includes

Microsoft SQL Server 2014 is supported
The ability to save and restore tabs is added
The ability to view columns and indexes in Object Explorer is added
Index Rebuild, Index Reorganize and Index Disable commands are added
Query plans can be saved visually
Results comparison is executed when the required elements are selected
Various queries plans can be shown vertically in one view when comparing
Buffer and plans cache refresh options are added
Zoom menu in the Profiler diagram is available

3.5.130 21-Nov-13

NullReferenceException on editing data in the Data Editor is fixed (T89961)
OutOfMemoryException on searching data in Data Editor is fixed (T88817)
Problem with the installation of the product is fixed (R28557)
The navigation from the Error List to the specific error in a script is fixed (T88471)

3.5.125 15-Oct-13

InvalidOperationException while executing queries on SQL Azure is fixed (T84559)
A problem related to the focus, while executing several statements is fixed (T84632)
A problem with highlighting of the IIF function is fixed (T84653)
NullReferenceException while working with a query that contains PIVOT (in Query Builder) is fixed (T84919)
Data export functionality to a CSV file is added. Now you can use column separator: tab, space, custom (T86071)
A problem related to the searching and replacing tabs and whitespaces is fixed (R28253)

3.5.120 19-Sep-13

NullReferenceException on adding rows in Data Editor is fixed (T84511)
NullReferenceException on retrieving data from the tables containing a BIGINT field is fixed (T74907, T75124, T75355, T75356, T75357, T75440, T83022)
Problem with saving a file's encoding is fixed (T83954)
NullReferenceException on executing a query is fixed (T83825, T84358, T84425, T84827)
Problem with removing a record in Data Editor is fixed (R26432)
Computed columns are now excluded from synchronization by default (T83409)
Error report when Estimated Rows exceeds the limits of integer in the Profiler document view is fixed (T83219)
Problem with generating a schema name when exporting data using the MERGE mode is fixed (T77218)

3.5.115 23-Aug-13

Problem in data editor with not assigning default values is fixed (T70859, R10060)
Problem with clearing memory on selecting data from table is fixed (T71228)
Problem with running the application on .NET Framework 4.5 is fixed (T75603)

3.5.105 12-Jul-13

NullReferenceException on editing a table in the editor is fixed (T72638)
NullReferenceException on invoking Help in the Command Line is fixed (R23315)
Error on changing connection in SQL document is fixed (R23354)
Work with memory is improved while redirecting data to the Output window (R22051)
InvalidCastException on editing a subquery in Query Builder is fixed (R20279)
The problem with applying a filter in Data Editor is fixed (T70060)
Incorrect behaviour with identity columns on adding data in Data Editor is fixed (T69095)

3.5.88 09-Apr-13

The problem with saving the Splitting options is fixed (T60064)
InvalidOperationException on executing a script is fixed (R17828)
The problem with changing options for code editor is fixed (T65707)
NullReferenceException on trying to find a search pattern in a document is fixed (R19287)
InvalidOperationException on editing data in Data Editor is fixed (T67547)
The problem with connection to TFS 11 is fixed (T61250)
The problem with punctuation's visibility in code editor with black background being set is fixed (T65696)
NullReferenceException on executing a script is fixed (T65230)
Syntax error on executing the current statement using the Execute Current Statement command is fixed (T68993)
Syntax error on executing a script with @@ variables is fixed (T62139)

3.5.68 15-Jan-13

NullReferenceException on opening the SMTP options page is fixed (T64010, T64950, T59614)
Problem with displaying 'Code Completion' options is fixed (T63344)
FileNotFoundException on opening the New File window is fixed (R15121)
SqlTypeException on executing stored procedure with data entered out of the permissible range (T64333)
InvalidCastException on double-clicking a table in Database Explorer is fixed (T64179)
Error on setting alias name in upper case is fixed (T15105)
NullReferenceException in Query Builder is fixed (T62199, T63974)
InvalidOperationException on refreshing data in Database Explorer is fixed (T60588)
NullReferenceException on creating a SELECT query in Query Builder is fixed (T63549)

3.5.46 08-Nov-12

SQL Server 2012 LocalDB is now supported (R14621)
ArgumentException on opening a file through the command line is fixed (T45824)
Incorrect trial on Windows 8 is fixed (T59119, T59496, T59563, T59698, T59827, T59847)
ArgumentNullException on finding the next occurrence in text is fixed (R13847)
NullReferenceException on profiling a query is fixed (T59489)
NullReferenceException on searching a text in SQL document is fixed (T59700)
InvalidOperationException on closing a connection with invalid transaction is fixed (R14818)

3.5.33 18-Sep-12

Query Profiler for locating bottlenecks and optimizing query execution time with advanced options unavailable in a standard tool added
Generate Script As in Database Explorer feature added
InvalidOperationException on executing a query is fixed (T42960, T41492)

3.0.20 18-Jul-12

Error "Object cannot be cast from DBNull to other types" on SQL server 2012 is fixed (T42098)
Start page scrolling bug is fixed

3.0.18 27-Apr-12

Query builder can now work with INSERT, UPDATE, and DELETE statements
Quick conversion of SELECT query into UPDATE or DELETE with preservation of WHERE expressions is added
Wrapping SELECT queries into INSERT ones is added
Execution of subqueries to check their validity inside a diagram is added
Transformation of selected data into SQL queries (for example, into INSERT queries) is added
Usability of the visual expression editor is improved
Label stating the type of statement is added to diagram
Editing of multiple execution results of one script on separate tabs is added
New start page is added

2.0.12 19-Oct-11

User reported bug fixes

Problems with trial checking are fixed

2.0.11 21-Jun-11

Customizable Data Export

Now, you can export data from one or even multiple tables at once to the following formats: CSV, DBF, HTML, MS Access, MS Excel, ODBC, PDF, RTF, Text, and XML. Before exporting you can customize export style attributes, such as text, background and border color, font, set output format of exported columns and preview the result.

Enhanced Data Editor

Sorting and grouping tables now works on a sever side
Ability to edit tables in JOIN statements is added
Ability to view tables united with a foreign key in a popup window is added
Many other minor improvements and extensions to existing functionality were made

User reported bug fixes

Behavior of the popup expression editor when working with functions was enhanced
Rows in the popup expression editor are automatically quoted now
NullReferenceException on editing a subquery in Query Builder was fixed (T25205)

1.00.40 20-May-10

Fixed bug with editing complex conditions.
Fixed bug with updating text view on query design change.

1.00.39 18-May-10

First release of dbForge Query Builder for SQL Server.