Downloads

Users who intend to write code in QueryStorm should use the Full version. The full version includes both the IDE and the runtime.

Users who will use the solutions built on QueryStorm but will not write code themselves should use the Runtime version.

Version History

2.12.524.0
·
Apr 12 '24
·
current
Snowflake fixes:
================
- Fixed an issue with C# code-behind for Snowflake scripts that use {handler}, {query}, and {function} directives
- Allowed multi-statement SQL scripts
Runtime Installer
MD5: 43D4A85F2B500806302D48C958D2EEA3
Size : 6.53 MB
Full Installer
MD5: 2F5C3B646D009FFD04B6F58F7A4377A1
Size : 38.13 MB
2.12.522.0
·
Apr 8 '24
SQLite engine: bringing back column type detection to be able to mark a column as containing dates. SQLite will not prevent other data types from being written into this column but will attempt to return values from it as dates.

SnowFlake: saving Snowflake scripts was broken. Now fixed.

Snippets: Fixed caret position after snippet completion.

ResultViewer: update columns when number formatting setting changes

SQL Preprocessor: fixed an issue with generating C# code from SQL queries with a {query} directive.

SQL Server scripts: additional built-in TSQL functions support in code editor (e.g. isnull)
Runtime Installer
MD5: 9946E9E1FE48BCAE6ACCB1540BB54560
Size : 6.53 MB
Full Installer
MD5: 945E0BE66FD257773DF05E89BC074D9B
Size : 38.13 MB
2.12.521.0
·
Mar 16 '24
Fix: SQLite Date Issue
=======================
Fixed an issue with Dates in the SQLite engine (regression). Neither Excel nor SQLite have a dedicated "date" data type; both simulate it using other types. Excel stores date values as double-precision numbers (OAdate), while SQLite can store them in multiple ways, depending on the DateTimeFormat setting in the connection string. In QueryStorm, by default, SQLite stores date values as double-precision numbers (JulianDay). This can be a problem, especially with dynamically generated values, as it's not straightforward to detect when a number returned by the SQLite engine should be treated as a date (and thus should be converted from JulianDay to a date) and when it should be treated as a regular number.

This was previously handled by detecting Excel column types and ensuring any value written to a column that contains only date values (formatted as dates) are converted to a date. This broke in a recent update, which turned off autodetection to enable C# scripts to write values of any type to any column when using the default data context.

In this commit, the SQLite engine gets this auto-detection again but the C# one does not (since C# does have a dedicated datetime type, this is not an issue with it).
Full Installer
MD5: 743285866A357A066BAB30FC24D2E5A9
Size : 38.06 MB
Runtime Installer
MD5: D160456D5C9B505754E85D772B10BBB1
Size : 6.53 MB
2.12.520.6
·
Mar 8 '24
Fixed a threading issue in Tabulars
Runtime Installer
MD5: DBABC0E0BC23E745C38FD73FC9554909
Size : 6.53 MB
Full Installer
MD5: 9CF62492994BCCCCE92F5FE6B42F74B9
Size : 38.06 MB
2.12.519.0
·
Mar 5 '24
Fix for functions not refreshing on parameter change
Full Installer
MD5: E8143231B303F2F5D2069D102B05D19C
Size : 35.74 MB
Runtime Installer
MD5: 8AC6F0690AF63BA4D12CCD91D0BA7E76
Size : 6.53 MB
2.12.518.1
·
Mar 4 '24
Hotfix for streaming functions defined in workbook apps:
They were showing up as #Name error when the workbook initially opened until the user recalculated. Now fixed.
Runtime Installer
MD5: AE0520823385C2CACA8EA1FB6F1ED703
Size : 6.53 MB
Full Installer
MD5: 159821D0F89DCAFCD55DE5BBCEE9ECDE
Size : 35.74 MB
2.12.518.0
·
Mar 4 '24
Runtime changes
===============
Streaming functions (like Windy.Query) will now correctly show up when openning a workbook, instead of showing up as #NAME error. Also included is a hotfix for v2.12.517 - after installing an app from the store, functions weren't showing up in tooltips until Excel restart (now fixed).

IDE changes
===========
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. Given that a datacontext and an ITabular represent a snapshot of external data, it is appropriate for the loading and saving operations to be async.

In addition, the SQL preprocessor has been changed to make functions and event handlers fully async. Previously they were sync by default, but it is approprite for DB access to always be async and, in case of event handler, cancellable.

This might unfortunately cause breaking changes in user code. The potential breaking changes are described below:
- The constructor of the WorkbookDataContext class has an additional parameter. This means that if you have a custom data context derived from this classes, you should update the constructor to accept (and forward to the base class constructor) the following parameters: IWorkbookAccessor workbookAccessor, ISyncRunner syncRunner, IWorkbookDataEventsSource workbookDataEventsSource. No other changes are necessary here.
- ITabular and IDataContext interfaces have been updated and are moving away from sync methods. This is unlikely to cause anyone a direct problem as user code usually does not use these directly.
- The "async" keyword has been removed from the SQL preprocessor as all operations are now async. Instead of {async function test()}, you can now write {function test()}, and async is implied. The same goes for event handlers. During execution of an event handler, a modal progress dialog will inform the user of the current operation and allow them to cancel execution. As a result, all SQL scripts that contain {handler}, {query}, or {function} preprocessor directives, MUST BE RE-SAVED to regenerate the codebehind. You can do this by making a trivial change in the script, e.g. add a space to the end of a line and then save the file. Also, any "async" keywords in the SQL preprocessor declarations must be removed.
- support for Google Sheets data contexts has temporarily been removed. If this is causing you problems, please get in touch with antonio@querystorm.com to vote to re-enable this sooner rather than later.
- ITabular now supports a small and fixed number of data types (bool, number, text, datetime, and any). Previously, columns could have been of any type, which was causing conversion issues when comparing data stored in Excel with data coming in from other systems (e.g. Monday.com or AirTable)

Note that this version does not involve breaking changes between apps and the runtime, so old apps will continue working with this runtime version and vice versa.
Full Installer
MD5: D382529187340BDC1292FFC6A496CB8E
Size : 35.74 MB
Runtime Installer
MD5: EC9559F6D6ADD27A332E8B0205D994A2
Size : 6.53 MB
2.11.514.4
·
Jan 19 '24
Installer fix
==========
- The XLL files were not getting signed, so they were getting blocked by some anti-malware programs

Misc
========
- updating SyncFusion components (results grid)
- slight improvement in code editor auto-complete lag
Runtime Installer
MD5: 5317265B4F5DA50E985AAB48D1BE838F
Size : 6.52 MB
Full Installer
MD5: A18DA21CEE78A38BA6138758E62DE783
Size : 35.62 MB
2.11.514.1
·
Dec 29 '23
New features
============
- This version adds basic Snowflake support as a new script type. Still missing is a UI to facilitate editing connection strings, as well as proper code analysis. Currently, the SQLite parser is used for code analysis (code completion, error highlighting, etc...), which means that the code editor might highlight errors where there are none (when using Snowflake syntax that isn't valid in SQLite). Improvements in this area will be added over time, as users interact with the initial version and request improvements.


Bug fixes
=========
- issue with returning empty 1d array from functions
- minor UI fixes
- document write times changed from local to UTC
Full Installer
MD5: 1FAE20D77E48C7C3CE8705C97BD6CC53
Size : 33.86 MB
Runtime Installer
MD5: 8D92397705AEB22C8D0B3D225C6853B1
Size : 6.48 MB
2.11.513.1
·
Dec 11 '23
Two problems fixed:
- Fixing Monday.com data context issues
- Fixing installer in-place upgrade issue
Full Installer
MD5: 3D0B66C30AC77CADA8973209FAC0389A
Size : 31.59 MB
Runtime Installer
MD5: E0BB2974A3DDE5523358F038018210BE
Size : 5.57 MB
2.11.512.0
·
Dec 8 '23
Summary
==================
This version mainly includes changes that revolve around building connector apps (e.g. MondayLink, a 2-way connector between Excel tables and Monday.com; for details find MondayLink on YouTube). The logic for building connector apps has been included into QueryStorm to make it easier to build connectors to other systems.

This version also includes a few important bug fixes and a couple of less important ones.

Due to a requirement to allow apps to request different kinds of licenses for different areas, the runtime API has been altered, which results in the breaking change described below.

Breaking change!
================
This version contains a breaking change in the API between the runtime and apps. This means that QueryStorm apps created with this version of the IDE will not run on previous versions of the runtime (2.10 or lower), they will require version 2.11 of the runtime. This change was done to better support the ability to license apps but a minor cleanup of the API was also done since we're already breaking backwards compatibility.

Apps will need to be recompiled with this latest version of the IDE to be compatible with the latest version of the runtime. No changes in code will be required and no behavioral changes should occur as a result.

Other changes:
==============
- added support for cancelling async function execution (previously it continued in the background even if the cell that made the call originally was cleared)
- updating monday.com library to latest API
- fixing a caching issue with tables
- updated (result) grid control to latest version
- minor UI refresh
- fixed issue of duplicate log entries when multiple instances of QueryStom are running in separate Excel windows
Full Installer
MD5: 9BBB953C97C448C222D8EE6A450CF33F
Size : 31.59 MB
Runtime Installer
MD5: 9E4510E052D9834B806EC9ACF43448E7
Size : 5.57 MB
2.10.511.1
·
Oct 31 '23
This version includes mostly internal changes (code cleanup and refactoring as well as several features needed by some of our built-in apps).
Full Installer
MD5: 2377D59311B33EC4E67560D46EB84C2C
Size : 31.56 MB
Runtime Installer
MD5: EC96FF1EF5BD0783677450DF35E5E588
Size : 5.56 MB
2.10.509.0
·
Sep 22 '23
This version includes a series of bug fixes:
============================================
- fix issue with multiple auto-complete dialogs showing for the same code file
- fix issue of the code editor losing focus each time a script is executed (now focus stays on the editor, but the results/message pane still gets brought to front if needed)
- fix issue with functions returning an empty 2d array (was showing up as 0 instead of blank)
- fixed issue with writing large number of guid values to an Excel table
- fixed issue with WorkbookDataStore not saving the timestamp when files change (so workbookdatacontext was always being detected as changed, on each build, even if it is up to date)
- forwarding all trace and console WriteLine calls to the messages pane (runtime, IDE and apps)
- going back to enforcing that apps load their own dlls instead of piggybacking on the runtime's dlls (which might be a different version)
- fixing a bug that was preventing pasting text from the windows clipboard history pane into the code editor using the Enter key (mouse click worked fine).
Full Installer
MD5: 196189DF3AADB1323F1DD0A3A7D865F2
Size : 31.3 MB
Runtime Installer
MD5: 9F70AD56EBAB8DB389D45D6AEECED1E3
Size : 5.56 MB
2.10.504.0
·
Aug 3 '23
Hotfix
=====
Fixing Excel interop issue which was introduced in the previous version (v2.10.503)

Other
=====
- additional fix for non-model dialogs e.g. the log viewer in the QueryStorm runtime (fixes issues with keyboard focus, resizing, moving)
- fixing an issue with list of installed packages being wrong when user removes packages and then rebuilds a new one
Runtime Installer
MD5: 20BD363FB2543B524887750026ECF88F
Size : 5.57 MB
Full Installer
MD5: CC8C89A05E4E13C806E66823B8EF4129
Size : 31.3 MB
2.10.503.0
·
Jul 23 '23
- Several UI fixes and tweaks
- Fix for "Log viewer" dialog drag/resize freezing windows UI
- Fix for QueryStorm external application shutdown behavior (to avoid leaving excel hanging after close)
- Fix potential deadlock scenarios when debugging with external QS application
- Including missing XML documentation files for QueryStorm
Runtime Installer
MD5: 78AA6259A2D50EC4C1F8AE1DB197CE55
Size : 5.57 MB
Full Installer
MD5: 3E30A0A553F175FA3FCE88F9810D8AB7
Size : 31.29 MB
2.10.502.0
·
Jul 19 '23
Fixes to the updater
====================
- added text wrapping in the "Summary" field
- separated "Summary" and "Release notes" into two tabs
- fixed hyperlink click behavior
- added icon to releases that have dedicated release notes

External QueryStorm application
===============================
- scripts now work right away, without manually selecting the active project (auto-selecting workbook project)
- removed deprecated commands from the main menu

IDE fixes
=========
- The IDE was unable to collect log messages from the runtime, now fixed.
- Displaying error message in a dialog in case of exception for all UI commands in QueryStorm (instead of silently failing)

Misc
====
- Fixing Ngen optimization for per-machine installation (requires admin rights). This improves initial startup time for C# scripts and code files.
- Enabled resizing certain tool windows (e.g. log viewer, connect dialog, etc...). This was broken since a recent version that updated the toolwindow style.
Full Installer
MD5: 4D339DE028BDCB3939636BBD288A2728
Size : 32.12 MB
Runtime Installer
MD5: 27B308434EC1E1F71A70B984DB777987
Size : 6.51 MB
2.10.501.0
·
Jul 12 '23
IMPORTANT NOTE
===============
Users who have the old version of the QueryStorm Runtime installed will need to manually uninstall it before installing this new version. This is a one-off issue and should not need to be done again in the future. This does not affect users who have the full version installed.

Runtime auto-updater
=================
Until now, runtime users did not get an "Update available" ribbon button when an update is available. This is now fixed so runtime users will get notified and can easily update when a new version is available.

Runtime installer changes
====================
Since the runtime is an XLL addon, it could not be installed per-machine. This version includes a new VSTO addin that acts as a loader for the runtime, effectively allowing the runtime to be installer per-machine.

Additionally, the UpgradeID of the runtime installer has been changed to match the one that the IDE uses. This prevents the user from installing both the Full and the Runtime version (which could cause problems).

New versioning scheme
====================
Moving to a more manageable versioning scheme. Until now, the last two numbers were auto-generated based on the date and time of the release, but these numbers were unwieldy (e.g. 2.9.8581.26987). The new version scheme uses major.minor.build.revision scheme (e.g. 2.10.501.0) as follows:
- Major: this will always remain version 2 (version 3 would be a separate product)
- Minor: increments here usually indicate a break in backward compatibility, meaning that e.g. apps created with v2.7 of the IDE will not run on v2.6 of the runtime. However, some apps might run fine if they don't interact with the changed areas. Also, in this release (2.10.501.0), this number has been incremented from 9 to 10 not because it breaks compatibility with v2.9 (it doesn't) but only because of the versioning schema change (to ensure that this version number is higher than the previous one (2.9.8581.26987).
- Build: this number will be incremented by 1 with each new version. I've chosen 500 as a starting point so this version starts as version 501.
- Revision: this number is currently not used and will likely be skipped or set to 0.

Solving "preview pane" issues in windows explorer
=================================================
When the user has "Preview pane" enabled in the Windows Explorer, an embedded Excel process is created to display the preview. In previous versions of Querystorm, this was causing all sorts of havoc with the QueryStorm runtime. In this version, the runtime is only loaded for actual Excel instances, not for the preview pane and app will work with the correct Excel instance, ignoring the preview pane one.

Other fixes
========
- Additional polishing of WPF dialog windows and fixing dialog centering issues
- Fixing external QueryStorm WPF application (loaded from the dropdown below in the QueryStorm ribbon)
Full Installer
MD5: E8062F6202A375FA3C0D9A04225485F7
Size : 31.95 MB
Runtime Installer
MD5: A03A82B8AC7A70C4991FA953E3BB6F0D
Size : 6.5 MB
2.9.8581.26987
·
Jun 30 '23
This release includes two important improvements:

1) The Runtime will no longer crash after an Excel file has been opened in the windows explorer's Preview pane. QueryStorm apps will connect to the correct instance of Excel (not the one in the preview pane). This should solve all issues related to the preview pane in windows explorer.

2) All dialogs have been polished and are now consistent across the IDE, runtime, and user apps.
Full Installer
MD5: 4426BD5C417AEB617994539936C65A31
Size : 32.47 MB
Runtime Installer
MD5: D99FF2D219AC624561E97D2AEDCE0A9C
Size : 5.4 MB
2.9.8577.30373
·
Jun 26 '23
Fixing issues with scripts for defining custom data contexts
Full Installer
MD5: 38B73B63F97E91CCAFE2D8AA365FCF06
Size : 32.46 MB
Runtime Installer
MD5: 3D5E7A2D8B63772D8EE322950CF33509
Size : 5.4 MB
2.9.8566.22073
·
Jun 15 '23
Fixing an issue with the QueryStorm Runtime where Excel was crashing when starting apps that register context menu commands, e.g. MondayLink.
Full Installer
MD5: 711327F81954BEF70817AEE8C79D223B
Size : 32.45 MB
Runtime Installer
MD5: E79B82C85E81AEE03C7C6583732F9690
Size : 5.4 MB
2.9.8558.14920
·
Jun 7 '23
Hotfix: VBA API was broken in the last few versions (since 2.9.8553.18963)
Full Installer
MD5: E79C0BCB33498CAB783B1803BABFAC3E
Size : 32.45 MB
Runtime Installer
MD5: 298B7F3062E9DEFFE0D32A3F918275DA
Size : 5.4 MB
2.9.8556.16519
·
Jun 5 '23
Fixing Monday.com data context issues
Full Installer
MD5: 4B267EE9293E71E98953E8B7AD0DBE2E
Size : 32.45 MB
Runtime Installer
MD5: 0871FCDFCC8DCD278679527171BE76A5
Size : 5.4 MB
2.9.8553.23923
·
Jun 2 '23
Hotfix: fixing the "Function Insights" functionality in the code editor
Full Installer
MD5: 842AF75D58CF4BD2B9B42B2E89C47CBE
Size : 32.45 MB
Runtime Installer
MD5: 49D7B5B6676B0CC3D32F55F097380B5D
Size : 5.4 MB
2.9.8553.18963
·
Jun 2 '23
This release fixes several important issues:

- compilation (build) was failing to resolve .NET references on machines that don't have the .NET SDK (installed with Visual Studio)
- Excel would hang for 15s on close whenever a dialog was shown by the IDE, runtime, or an app.
- QueryStorm runtime would not load if a running file explorer instance has started Excel in the preview pane (though there's still an issue with a phantom Excel window showing up if used in the preview pane - to be fixed)
- switching to the latest version of ExcelDNA to fix a bug that was crashing Excel on load when apps that define context menus are used
Runtime Installer
MD5: B38FAA216BFD4058104369816A487977
Size : 5.4 MB
Full Installer
MD5: 5C764C27AF85B16DA896FF4F435EC31D
Size : 32.45 MB
2.9.8525.20169
·
May 5 '23
Breaking change:
=====================================
Due to changes in the runtime/apps contract, the version number has been incremented from v2.8 to v2.9, indicating a breaking change. The runtime now passes its version to apps so they can prompt the user to update the runtime, if necessary. When an app is built with the new version of the IDE, it will not run on older versions of the runtime (if <2.9). However, the app will prompt the runtime user to update the runtime.

List of changes in this version:
================================
- Apps can now specify a minRuntimeVersion
- Added infrastructure for http request for throtting and API key management (request/try/retry loop)
- Improvements in handling licensing prompts (avoid multiple prompts for licensed functions evaluating in multiple cells)
- IDialogServiceExt interface added that allows apps to show dialogs from XAML files and VM objects
- Support for C# scripts returning ExpandoObjects
- Fixed referencing BCL types in the IDE (using ReferenceAssemblies folder instead of GAC)
- IDialogService: all dialogs are show center screen, close on "Esc" key and allow hyperlinks that open the browser
- All licensing dialogs will share remembered username regardless of app
- Syncrhonization context is now assigned inside async Excel functions (so execution after async calls will resume on the main thread)
Runtime Installer
MD5: 86FF8AD162DF724FCA9AE88F55AA9F9F
Size : 5.48 MB
Full Installer
MD5: 7A0355EB4A9330CEAD649DBC724508A6
Size : 33.67 MB
2.8.8511.24477
·
Apr 21 '23
- Fixing issue with checking license in custom Excel functions in QueryStorm apps
- Minor "publish package" fix
- Minor tweaks to activation UI
Runtime Installer
MD5: 2BD19E11438CFB0B903A9FD0B3F3BB8B
Size : 5.48 MB
Full Installer
MD5: D72F08E9364F5A4D2C83486C78820726
Size : 33.66 MB
2.8.8507.32115
·
Apr 17 '23
Minor patch to licensing UI. Primarily important for new users.
Runtime Installer
MD5: 7F503CBA3469251D8B1C499379083695
Size : 5.48 MB
Full Installer
MD5: FE379FA57B52265F6B6E9125F8FC6D0A
Size : 33.65 MB
2.8.8503.17156
·
Apr 13 '23
New features
==========
- ability for app developers to license and charge for their apps
- ability for C# scripts to reference other C# scripts

Improvements and bugs fixed
=======================
- The "About" page was not getting disabled even for users with paid licenses
- The table cache was getting updated on each change in Excel, instead of only when the change intersects with a table leading to slow editing of Excel files with large tables
- Improvements in the licensing UI
- Added [view in browser] link in the updater UI
- Fixing StDev function in SQLite
Runtime Installer
MD5: AC886A5D19DAF0DB6F65D0FAECB77EE6
Size : 5.48 MB
Full Installer
MD5: AEC8B0A77EAC452A617B2C7AD3781CF3
Size : 33.65 MB
2.7.8487.32462
·
Mar 28 '23
- GPT copilot for SQL scripts added
- About sheet added (can't be removed by community users)
- Minor upgrades for custom Excel functions via C#

See release notes url for details
Full Installer
MD5: 7A9563F0BB619FB2A43F628C577B371A
Size : 33.65 MB
Runtime Installer
MD5: 7955CEA4B3C2E364EFE3477F03876899
Size : 5.45 MB
2.7.8439.23800
·
Feb 8 '23
Bugs fixed:
===========
- editing scripts was impossible after closing and reopening them
- phantom "lib" and "bin" files were appearing in extension projects after build
- failing async functions were crashing Excel instead of returning an error and logging the details
- workbook apps that have settings were bugged in multiple ways
- workbook variables now have a specific type (e.g. "double", "string"... instead of "object")
- sporadic deadlocks were occurring when using the {@some_table} directive
- sporadic deadlocks were occurring when closing workbook apps
- code generation templates for {query} preprocessor directive were broken if more than one parameter was declared
- workbook events were firing before their values were updated via data-binding (e.g. an event handler method might react to a cell change, but the event would get fired before data-bound properties were updated resulting in the event handler using stale data)
Runtime Installer
MD5: B0B437BEBB88714808ED40D9EB124072
Size : 5.38 MB
Full Installer
MD5: EF8E046EDBCE7169E3570B7800B979B1
Size : 32.03 MB
2.7.8416.27485
·
Jan 16 '23
Fixes to logic that detects new tables and table changes
Runtime Installer
MD5: A317847E6F9D32339707B49D74601CC2
Size : 5.38 MB
Full Installer
MD5: FF5CC07F5148A2F9067F8416587FB5EF
Size : 32.03 MB
2.7.8358.17658
·
Nov 19 '22
=== BREAKING CHANGE (MINOR) ====
This version includes an update to the SQLite engine. Existing workbooks and apps that use SQLite should have their project.config modified.
The following section in the project.config file should be replaced:

"NativeReferences": [
"x86\\SQLite.Interop.QS115.dll",
"x64\\SQLite.Interop.QS115.dll"
],

...with:

"NativeReferences": [
"x86\\SQLite.Interop.QS117.dll",
"x64\\SQLite.Interop.QS117.dll"
],
===============================

Bugs fixed
==========
- several user interface issues (white font on white background in flyouts, text alignment in several places)
- issue when deleting tabular rows
- the code explorer was not detecting external file changes
- Excel functions that accept CallerInfo (e.g. Windy.Query) were broken

Changes
=======
- updated to latest version of SQLite (supports right and full joins)
- updating a ListObject no longer overwrites formula columns
Runtime Installer
MD5: 1825EF5502CECFB81FB8E8AAABCBC21B
Size : 5.38 MB
Full Installer
MD5: 227EB68511A4E9AE7B39AAB71CC093C5
Size : 32.03 MB
2.7.8355.18354
·
Nov 16 '22
Hotfix
=========
A bug with the data context was preventing loading large tables so workbooks with large tables were not visible to QueryStorm at all.

Changes
=========
SQL scripts that use the {query()} preprocessor directive now generate a Run(...) method that returns a tabular and, optionally (in case there are results in the grid during save), an additional RunWithStronglyTypedResults(...) method that returns the strongly typed results.
Runtime Installer
MD5: A162B18836A73CC8D32066A43FAA4FF5
Size : 5.38 MB
Full Installer
MD5: 686BD4E7F05BED47B5740EE75879CAD2
Size : 31.99 MB
2.7.8347.16320
·
Nov 8 '22
The main focus of this release is making sure the QueryStorm installer clears all anti-virus scans. This primarily affects new users, but several additional fixes are also included.

Bugs fixed:
- A phantom file was showing up in the code explorer for SQL scripts that have {query/function/handler} directives, but only in extension (machine-level) projects.
- Resizing the log window in the QueryStorm runtime was freezing the UI.
- The runtime was reporting the wrong version number in the log messages.
- Updated the ExcelDNA library to ensure all antivirus vendors are clearing the QueryStorm runtime installer.
Runtime Installer
MD5: 5072859E42070D69BA26D3155D026996
Size : 5.38 MB
Full Installer
MD5: A5F380DF1F726043A62EF550317B03E0
Size : 31.99 MB
2.7.8343.23135
·
Nov 4 '22
Bugfixes
========
- fixing ngen support i.e. startup performance optimization (for per-machine installations)
- fixing bug with SQLite queries with "OR" expressions in the "WHERE" clause
- switching to a newer version of ExcelDNA that addresses malware false positives

Changes
=======
- copying results from the results grid no longer includes the column headers

New features
==========
- Abiltiy to navigate the caret position history in the editor using Alt+LeftArrow (back) and Alt+RightArrow (forward)
Runtime Installer
MD5: D0127BDF43A1EF9ED01968C203138540
Size : 5.38 MB
Full Installer
MD5: A6F5BFDB1D3D469C131A4940860BA4B3
Size : 32 MB
2.7.8337.21111
·
Oct 29 '22
Fixing issue with Microsoft.Extensions.Logging.Abstractions package that was preventing load for apps that define configuration objects
Full Installer
MD5: CC2AE95B1A8FDFC66C00696716461B5A
Size : 32.01 MB
Runtime Installer
MD5: 0F6BC6CC2F7EF454ABF933D10DCB4FB7
Size : 5.39 MB
2.7.8330.38394
·
Oct 22 '22
Bugfixes:
===================
- fixes across the board to the integrated debugger
- fixed deadlock when recompiling a project that contains a function that is in use in an open workbook
- fixed writing result as excel table (reapplying filters and inserting into empty table)
- fixed log window in the QueryStorm runtime (it would not start in cases where multiple Excel windows were open once the first one is closed)
- large performance improvements for component that are data bound to workbook tables
- bugfixes and performance improvements in the SQLite engine when working with Excel tables
- various misc bugfixes

Changes:
========
- data contexts now have an event that fires when a variable's data changes
- reorganizing app shortuts and added a template for generating shortcut classes
- code explorer reorganized slightly and several bugs fixed
- updated most 3rd party libraries to latest version
- qs version number can be read from the QueryStorm.Tools assembly and is now logged to the log window
Runtime Installer
MD5: A46FC31AC1CF6C4C40DD72FD775A644E
Size : 5.39 MB
Full Installer
MD5: ECA32B272B34F5F976B5F9C084BB2677
Size : 32.01 MB
2.7.8201.15774
·
Jun 15 '22
Bug fixes
============
- Added missing 32-bit IDE .exe file (for launching the external IDE app from 32 bit version of Excel)
- SQLite table indexes were not being used in correlated queries, so these queries were slow to run
- SQLite was not handling empty result sets correctly
- The CancellationToken in the ProgressDialog was not working correctly when used inside of a loop
Full Installer
MD5: E7B45E2593C26109FEAC87ADEE5829A5
Size : 30.64 MB
Runtime Installer
MD5: FAE3248087CF8C759621416CF89A1092
Size : 4.58 MB
2.7.8194.15084
·
Jun 8 '22
IDE fixes:
- results grid sorting and copy-paste now work again (was broken in previous version)
- significant code editor performance improvements for both C# and SQL code (more responsive while editing large files, faster autocomplete)
- fixed templates for generating code-behind files for SQL scripts for both C# and VB.NET
- significantly improved C# auto-formatting perfomance for large files

Runtime fixes:
- performance issue fixed when writing values cell-by-cell into Excel. Each write was causing the workbook data context to refresh which was causing severe performance problems
- improving overall querying performance of Excel (and other) tables
- resolving a threading issue that caused extension apps to interact with Excel on the wrong (non-UI) thread
Runtime Installer
MD5: 277BEFBEDC8F037D914670769187F31D
Size : 4.58 MB
Full Installer
MD5: E87ED05FC074427BB4F899A8078F9DC3
Size : 30.64 MB
2.7.8186.15420
·
May 31 '22
IDE:
- various IDE fixes (error line selection, issues with multiple Excel windows open, C# code editor tooltips for generic types fixed)
- overhauling Tabular class (now ITabular interface)
- support for additional data context types: google sheets and monday.com
- basic support for using XAML for defining UI in apps

Runtime & libraries:
- dialogService now has OpenProgressDialog method that displays the progress of an async operation and allows the user to cancel the operation
- async component event handlers can automatically get a progressObserver
- new library for creating "connector" apps that allow "binding" excel tables with external data
- preserving app settings on rebuild but removing them on uninstall
- better error handling when apps fail to load
Full Installer
MD5: 623669286E8E020857C920037BDA6681
Size : 30.63 MB
Runtime Installer
MD5: 330B2D4ACEA146FB8FB4FB7F768ADAEC
Size : 4.58 MB
2.6.8092.14763
·
Feb 26 '22
Fixed bugs (IDE):
====================
- double-clicking an error in a file which was not previously opened would only open the file, not go to the offending line
- C# indentation strategy was not working well with lambdas so reverting to a simpler indentation strategy (for now)
- IDataContext could not be resolved from C# scripts
- importing a workbook project into the workbook was failing to update files properly
- creating a new project after deleting the project with the same name was throwing an exception
- if the default SQLite connection string was deleted in project.config, trying to create a new SQLite script would fail (it now recreates the default connection string)
- the (docked) debugger was running into many issues when debugging code that interacts with the Excel API (was caused by an error in the mechanism that allows the debugger to stay interactive while debugging Excel)

Fixed bugs (runtime):
====================
- installer version number was wrong (1.0 instead of 2.6), which was causing issues with upgrading
- better error logging when data context schema does not match values in a table (e.g. null value found in a non-nullable table column)
- context menu category was visible even if no items inside it were
- IDialogService.ShowWindow() and ShowWindowDialog() methods were not working

Improvements:
====================
- ability to recreate the output table when running SQL scripts. To force the output table to be recreated (overwrites existing columns) add a "!" after the table name, e.g. {@myOutputTable!}
Full Installer
MD5: 22E773A2501BDEC9A9538850044358A9
Size : 28.1 MB
Runtime Installer
MD5: 868B3AAEEE5B9514A1F2803672CC1240
Size : 4.57 MB
2.6.8077.19007
·
Feb 11 '22
- Introducing C# and VB.NET debugger
- Ability to run QueryStorm IDE as external application
- Improvements to package manager (fixing available updates view)
- Various fixes, improvements, and changes (minor breaking changes - recompiling qs apps is needed)
Full Installer
MD5: 4A3E05B4B4880494C62DFE7173C5F6C2
Size : 28.1 MB
Runtime Installer
MD5: 5B0547505A369DD6E9D689209D753895
Size : 4.57 MB
2.5.7923.20438
·
Sep 10 '21
- Fixing the problem with the default workbook data context that prevented its use (the workaround was creating an explicit data context)
- When using [BindTable] the binder can now detect the table name based on the property type, if it is a table wrapper class (but not if it is Tabular)
- SQL preprocessor now forbids illegal combinations of declarations (e.g. can only use {@tbl} in a handler but not in a function or query) and gives better error information
- Fix encoding issue with .cs files that are created via a code fixer (e.g. extract class into its own file)
- Adding a "netstandard.dll" reference into the default config file as many current NuGet packages rely on it
- Support for configuring SSL in Postgres connection strings
Runtime Installer
MD5: 4E3CFB52D4DC3E0DA5F16A85F3327D4A
Size : 4.38 MB
Full Installer
MD5: ED1C5F50178FA3D36AFC1BAEC051EB70
Size : 29.66 MB
2.5.7914.20852
·
Sep 1 '21
- Hotfix: existing projects that used SQLite fail to load with the new 2.5 version. This hotfix fixes this (check release notes for details)
- Syntax highlighting for the new C# 9 "with" keyword
- Displaying compilation warnings even if build succeeeds


Full Installer
MD5: 68E71EF6C6BAEE177736035DB6D9A883
Size : 29.84 MB
Runtime Installer
MD5: A58F32C645BC1C3C2F09C22292C41C3F
Size : 4.38 MB
2.5.7913.28115
·
Aug 31 '21
- Upgrading from C#7 to C#9 (support for records, nullable reference types, async streams!)
- Upgrading from SQLite 3.15.2 to 3.36.0 (support for window functions!)
- Easy Excel function results caching
- Several
Runtime Installer
MD5: BEA0F5ABD3FEF2D698E3A819E0164CF4
Size : 4.38 MB
Full Installer
MD5: 64A91E942750A428791D696B72D5267F
Size : 29.84 MB
2.3.7891.32861
·
Aug 10 '21
- Trusted documents (runtime security feature for workbook apps)
- Easier context menus in apps
- Easier settings in apps
- Various bugfixes and improvements
Runtime Installer
MD5: F50CF3FF4C3E86937436DD00907F5DA9
Size : 4.3 MB
Full Installer
MD5: E2E90ECA0F7436ACA8F7FC464E8B3566
Size : 27.93 MB
2.3.7824.17314
·
Jun 3 '21
Summary
=======
This version is a collection of bug fixes. There are no breaking changes in this version.

Fixes
=======
- fixed compilation of projects with references to local system dlls
- minor fixes to ribbon class template
- fixed publishing packages with native dlls
- prevent creating multiple projects in a workbook, as this scenario is not yet supported
- better handling for project load errors
- better handling for async function crashes
- fix a focus issue with the undocked QueryStorm window where all text input would go to Excel
- fix for project deletion issues (add error logging, allow deleting projects with readonly files/folders)
- fixed minor ui issues in the undocked ribbon
Full Installer
MD5: 23570F6640D79B0F08D4A1D05A8B9E7D
Size : 27.75 MB
Runtime Installer
MD5: C5AAFA37E589E26FA5C5718FE9DE5668
Size : 4.3 MB
2.3.7822.26514
·
Jun 1 '21
Apps
======
- Added support for defining ribbons in apps

SQL preprocessor
======
- async functions
- functions that include headers in results
- async event handlers
- queries (for use from .NET code)

Data contexts
======
- complete overhaul of data contexts: switched to C# script for defining data context
- added support for CSV data contexts

Fixes
======
- fixed Excel process crash on exit in certain situations
- fixed Excel process crash on disable runtime Excel Addin
- fixed problem with nesting user defined Excel functions
- fixed activation issue for SQL Pro licenses
- fixed deadlocks in certain situations
- fixed some data handling issues in SQLite
- fixed dozens of IDE issues (logging, code editing, UI glitches)
- fixed handling of special values in user defined functions (error values, missing values)
- fixed installer issue for versions of Excel installed from the windows store
- reorganized confusing connection dialog

Breaking changes
==============
- SQL preprocessor syntax change for commands (event handlers): instead of e.g. {handles eventName} now it's {handler (eventName)}
- new apps will not work on the runtime from previous versions due to a change in the API of the runtime. This change was needed to allow apps to register their own ribbons.
- in projects, data context files will need to be recreated, because the new data context approach has changed
Runtime Installer
MD5: 33A8E2432B314836DEF98FDB07EFFE0B
Size : 4.3 MB
Full Installer
MD5: 713B3128CF0A650A081C3E2F351E4E09
Size : 27.74 MB
2.2.7760.18802
·
Mar 31 '21
Version 2 is here!
Full Installer
MD5: AC042517B43F704BED0EF7984E163902
Size : 27.61 MB
Runtime Installer
MD5: 285A281AB51AA13BB20A267AAD7B1134
Size : 4.27 MB

Get Started!

Read the documentation to
learn how to use QueryStorm.

Contact sales

Contact us for any licensing
or sales related questions.