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

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

Version History

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
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
May 31 '22
- 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
- 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
Size : 4.58 MB
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

- 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
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
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
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
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
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
Jun 3 '21
This version is a collection of bug fixes. There are no breaking changes in this version.

- 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
Jun 1 '21
- 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

- 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
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.