Hotfix: fixing the "Function Insights" functionality in the code editor

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

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)

- Fixing issue with checking license in custom Excel functions in QueryStorm apps
- Minor "publish package" fix
- Minor tweaks to activation UI

Minor patch to licensing UI. Primarily important for new users.

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

- 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

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)

Fixes to logic that detects new tables and table changes

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

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.

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.

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)

Fixing issue with Microsoft.Extensions.Logging.Abstractions package that was preventing load for apps that define configuration objects

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

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

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

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

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!}

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

- 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

- 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

- 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

- Trusted documents (runtime security feature for workbook apps)
- Easier context menus in apps
- Easier settings in apps
- Various bugfixes and improvements

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

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

Version 2 is here!