Version 3.5

• Use of coding history cache has been turbo-charged. Code suggestions based on historical coding patterns are available in many places.
• Eclipse plug-in. That's right, SQL Assistant can now be used with Eclipse and derivative products including Eclipse Data Tools Platform.
• Multiple column selection lists are supported in UPDATE and INSERT statement. Checkboxes have been added to these column lists allowing to choose multiple columns at once.
• Multiple-column foreign keys are supported in JOIN clauses. The entire JOIN with all columns can be now added with a single mouse click or a single key-press.
• New Code Bird's View feature helps to navigate long files and scripts, supporting jumps between code fragments without scrolling and reading the actual code.
• New coding statistics and productivity gain display. Some of our internal tests achieved as much as 1200% productivity gain from using SQL Assistant! Try it for yourself.
• Additional code-wrapping options have been added to formatting rules.
• Support for batch delimiters available for all environments, including parsing and support for MySQL's DELIMITER keyword and DB2's SET TERMINATOR.
• Expanded support for Oracle objects and packages - added code IntelliSense for types, type and package constants, exception handlers and declarations, package and type scope records.
• New code block commenting/uncommenting function can be used with non-SQL editors such Notepad, UltraEdit and other not supporting such commonly used function.
• Numerous other minor enhancements and usability changes.

Version 3.1

• Direct code execution – Notepad and all other simple editors can now fully compete with specialized SQL editors and development environments.
• Table data mini-preview (single-click on a table, view, or synonym shows first 100 records)
• Support for MS Access as a back-end database, via direct integration with Access IDE and via ODBC database connection from other SQL editors (for example, you can now run MS Access queries and make data changes from Notepad).
• Data export to Excel and text files.
• SQL Code Structure support for CALL statements and other enhancements in the Structure view.
• DB2 and MySQL – support for FOR NOT FOUND and CURSOR..FOR constructs.
• Connection interception for SSMS in SQL Server 2008 (Katmai).
• Add-on registration for SSMS in SQL Server 2008 (Katmai)
• Branch expansion in popups and enhanced multi-level item filtering in expanded branches.
• Full support for synonyms in SQL 2005/2008
• New options to fully or partially qualify object names.
• Formatting code enhancements – added support for code structures beginning with the same keyword, for example, BEGIN and BEGIN TRY
• Logical join completion for subqueries - joins between tables referenced in the main query and tables referenced in subqueries.
• Support for join candidates using matching column names.
• Introduced 2 new macro-variables in code snippets for generating vertical column and parameter lists.
• Improved code auto-indent handling.
• Reworked and expanded database connection handling. Starting with this version ADO.NET-based and ODBC-based connections can be used with all supported database systems. For ODBC-based connections both DSN and DSN-less connections are now supported.
• Client-side authentication is now supported for DB2 and Sybase database connections using ADO.NET interfaces.
• Numerous other minor enhancements and usability changes.

Version 3.0

• Context SQL suggestions based on the typing history
• Matching brackets and code block delimiters (BEGIN..END, IF..END IF, LOOP..END LOOP, etc...) highlighting and one-click navigation
• One-step complete SELECT statement generation after selecting columns in SELECT prompt
• Support for multiple-column selection using check boxes in SELECT and other prompts
• Advanced Auto-indent features
• Support for procedure parameters in MySQL
• Support for subqueries and derived tables with variable parameters in SQL Server
• Code syntax validation for DB2 and MySQL
• Support for objects and columns declared in temp tables and table variables
• Code expansion for * and other elements in DML statements
• Advanced code completion in DML statements and statement generation based on selection of a JOIN or WHERE clause
• Context suggestions for code expansion in DDL statements. Context sensitive help with DDL commands
• Support for multiple formatting styles
• Advanced code snippets for auto-generating object-specific code fragments
• Advanced selection and code generation of variables in DECLARE statements
• Improved popup activation after dot or bracket
• Auto-generation of table aliases
• Support for MySQL native client connections
• MySQL Query Browser Connect Interception
• IntelliSense list content filtering control added to Options
• Improved code formatting - control of bracket positioning
• Built-in add-ons for SSMS, VS, VS for Database Team Professionals (former Data Dude)
• Support for Toad for MySQL/DB2/SQL Server
• Expiremental support for Sybase databases
• Other minor improvements over version 2.x

Version 2.5

• New one-click Procedural Code View - with a single click you can lookup and browse code of referenced procedures, functions, packages or just type the object name and click it to see the code of that object
• New integrated spell checker for SQL code comments and hard-coded string
• Improvements in Code Formatter and Beautifier
• Smarter IntelliSense in the code auto-completion features
• Enhancements in the Code Structure View - added support for loops and conditional statements, support for more types of SQL commands
• Added support for more SQL editors and IDEs
• Significant improvements made in the Options making it easier then ever to customize SQL Assistant behavior
• Other minor improvements over version 2.0

Version 2.0

• Support for MySQL and DB2 databases and editors
• Support for more editors and IDEs for SQL Server and Oracle with more flexible customization options
• Code Structure View for quick code navigation - anyone who deals with large SQL files would much appreciate this new feature
• Advanced code Intellisense and auto-completion for extended set of SQL commands, including many DML and DDL commands
• New code auto-expansion options
• Smart code auto-indent feature
• Code Formatter and Beautifier
• Code syntax validation for all Oracle and SQL Server editors, can be used even with Notepad
• Other minor improvements over version 1.0