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.9.8553.23923
·
Jun 2 '23
·
current
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
Full Installer
MD5: 5C764C27AF85B16DA896FF4F435EC31D
Size : 32.45 MB
Runtime Installer
MD5: B38FAA216BFD4058104369816A487977
Size : 5.4 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.
Full Installer
MD5: FE379FA57B52265F6B6E9125F8FC6D0A
Size : 33.65 MB
Runtime Installer
MD5: 7F503CBA3469251D8B1C499379083695
Size : 5.48 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
Full Installer
MD5: AEC8B0A77EAC452A617B2C7AD3781CF3
Size : 33.65 MB
Runtime Installer
MD5: AC886A5D19DAF0DB6F65D0FAECB77EE6
Size : 5.48 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
Runtime Installer
MD5: 7955CEA4B3C2E364EFE3477F03876899
Size : 5.45 MB
Full Installer
MD5: 7A9563F0BB619FB2A43F628C577B371A
Size : 33.65 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.
Full Installer
MD5: 686BD4E7F05BED47B5740EE75879CAD2
Size : 31.99 MB
Runtime Installer
MD5: A162B18836A73CC8D32066A43FAA4FF5
Size : 5.38 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.
Full Installer
MD5: A5F380DF1F726043A62EF550317B03E0
Size : 31.99 MB
Runtime Installer
MD5: 5072859E42070D69BA26D3155D026996
Size : 5.38 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)
Full Installer
MD5: A6F5BFDB1D3D469C131A4940860BA4B3
Size : 32 MB
Runtime Installer
MD5: D0127BDF43A1EF9ED01968C203138540
Size : 5.38 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
Runtime Installer
MD5: 0F6BC6CC2F7EF454ABF933D10DCB4FB7
Size : 5.39 MB
Full Installer
MD5: CC2AE95B1A8FDFC66C00696716461B5A
Size : 32.01 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
Full Installer
MD5: ECA32B272B34F5F976B5F9C084BB2677
Size : 32.01 MB
Runtime Installer
MD5: A46FC31AC1CF6C4C40DD72FD775A644E
Size : 5.39 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
Full Installer
MD5: E87ED05FC074427BB4F899A8078F9DC3
Size : 30.64 MB
Runtime Installer
MD5: 277BEFBEDC8F037D914670769187F31D
Size : 4.58 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
Runtime Installer
MD5: 330B2D4ACEA146FB8FB4FB7F768ADAEC
Size : 4.58 MB
Full Installer
MD5: 623669286E8E020857C920037BDA6681
Size : 30.63 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


Runtime Installer
MD5: A58F32C645BC1C3C2F09C22292C41C3F
Size : 4.38 MB
Full Installer
MD5: 68E71EF6C6BAEE177736035DB6D9A883
Size : 29.84 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
Full Installer
MD5: 713B3128CF0A650A081C3E2F351E4E09
Size : 27.74 MB
Runtime Installer
MD5: 33A8E2432B314836DEF98FDB07EFFE0B
Size : 4.3 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.