QueryStorm Releases

Learn what's new across releases, with details of features, enhancements, and resolved issues.

Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
QueryStorm 2.12.524.0Apr 12, 2024
Fixes
  • Snowflake Fixes:
    • Fixed an issue with C# code-behind for Snowflake scripts that use {handler}, {query}, and {function} directives.
    • Allowed multi-statement SQL scripts.
QueryStorm 2.12.522.0Apr 8, 2024
Features
  • You can now allow multi-statement SQL scripts.
Fixes
  • Fixed an issue with C# code-behind for Snowflake scripts that use {handler}, {query}, and {function} directives.
QueryStorm 2.12.521.0Mar 16, 2024
Fixes
  • Fixed SQLite date issue.
QueryStorm 2.12.520.6Mar 8, 2024
Fixes
  • Fixed a threading issue in Tabulars.
QueryStorm 2.12.520.5Mar 7, 2024
Features
  • A new type of script for connecting to Oracle databases has been added. Oracle SQL scripts can be created from the QueryStorm ribbon and the project context menu. Excel tables can be made visible to these scripts as private temp tables.
Fixes
  • Fixed issue with the script "connect" dialog which prevented configuring list of tables that should be visible to the script.
  • Minor UI improvements to script "connect" dialog.
  • Fixed templates that generate C# codebehind for SQL scripts .
QueryStorm 2.12.519.0Mar 5, 2024
Fixes
  • Fix for functions not refreshing in parameter change.
QueryStorm 2.12.518.0Major versionMar 4, 2024
Features
  • This version includes an overhaul of ITabular and IDataContext interfaces used extensively through QueryStorm, though mainly under the hood. The main change is that async methods are replacing the previous sync methods.
  • The SQL preprocessor has been changed to make functions and event handlers fully async. Previously they were sync by default, but it is appropriate for DB access to always be async and, in case of event handler, cancelable.
Fixes
  • Streaming functions (like Windy.Query) will now correctly show up when opening a workbook, instead of showing up as #NAME error.
  • After installing an app from the store, functions weren't showing up in tooltips until Excel restart.
QueryStorm 2.12.518.1Mar 4, 2024
Fixes
  • Hotfix for streaming functions defined in workbook apps.
QueryStorm 2.11.514.4Jan 19, 2024
Features
  • Updated Syncfusion components (results grid).
  • Made a slight improvement in code editor auto-complete lag.
Fixes
  • Installer fix - The XLL files were not getting signed, so they were getting blocked by some anti-malware programs.