sql - QueryStorm

Features: With QueryStorm’s SQLite engine, you can work with Excel tables as if they were database tables. Use SQL to clean, query and process live data inside Excel, without the need to import/export data. ...

Features: start expansion and more... Full autocomplete for SQL and C# Weight:  0 Error hints for faulty code Weight:  0 SQL star expansion Weight:  0 Tooltips display function/parameter documentation Weight:  0 ...

Screenshots: 0 ...

Screenshots: 0 ...

Release Notes: You can now allow multi-statement SQL scripts. Fixed an issue with C# code-behind for Snowflake scripts that use {handler}, {query}, and {function} directives. 0 ...

Release Notes: 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 ... "connect" dialog. Fixed templates that generate C# codebehind for SQL scripts. 0 ...

Release Notes: 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 ...

Description: It’s an IDE and runtime that allows using SQL and C# inside Excel making spreadsheets much more useful and accessible to tech users. For tech users who spend any considerable time in Excel, lack ... of proper support for tech skills tends to be a source of frustration. The purpose of QueryStorm is to greatly reduce this problem by adding easy and convenient support for SQL and C# into Excel, as well ... Speaks your language- Use SQL, C#, and VB.NET right inside Excel to process data, build custom functions and automate workbooks. Intelligent IDE- Code completion, syntax highlighting, code fixes, and much ...

Release Notes: 2.7.8487.32462 Updated Mar 28, 2023 Features QueryStorm GPT-powered Copilot- Added the new GPT-powered copilot for QueryStorm. This AI-driven feature lets you generate SQL code based on SQL ... comments. SQL Code Generation from Comments- With the copilot, you can now generate SQL code by simply writing a descriptive comment. The AI will understand your intent and generate the code accordingly. You ... can invoke the copilot when you press Ctrl+Enter while the cursor is on a single-line SQL comment. The generated code is placed between two comments, allowing you to easily identify the AI-generated ...

Release Notes: SQL Preprocessor adds async functions and event handlers. 2.3.7824.17314 Updated Jun 3, 2021 Fixes Fixed compilation of projects with references to local system DLLs. Minor fixes to ribbon class ... with read only files/folders). Fixed minor UI issues in the undocked ribbon. 2.3.7822.26514 Updated Jun 1, 2021 Features Apps Added support for defining ribbons in apps. SQL Preprocessor Async functions. ... issue for SQL Pro licenses. Deadlocks in certain situations. Some data handling issues in SQLite. Dozens of IDE issues (logging, code editing, UI glitches). Handling of special values in user defined ...

Features: QueryStorm supports connecting to external databases including SQL Server, PosgreSQL, MySQL, Oracle, DB2, SQLite and Access. When connecting, you select which Excel tables will be visible ...

Release Notes: New Debugger allows you to debug apps inside QueryStorm. 2.6.8092.14763 Updated Feb 26, 2022 Features Added the ability to recreate output tables when running SQL scripts. Fixes Fixed bugs (IDE): ...

Pricing: QueryStorm 2.x Prices are per seat. All licenses are perpetual and include 1 year of support and upgrades. SQL Professional License Our Part No: 555432-1267343 Developer License Our Part No: ... 555432-1267344 QueryStorm 2.x- Renewals Extends your support and upgrades for a further year. SQL Professional License Renewal Our Part No: 555432-1267346 Developer License Renewal Our Part No: 555432-1267347 ...

Release Notes: 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 ...

Release Notes: setting up automation is now done via code instead. This change highly improves automation performance, and offers.NET developers a rich, stable, and fast workbook automation API. SQL users should ... not be harmed by this change either, as they can now set up automation as part of their SQL scripts, using a very simple preprocessor syntax. They do not need to know any other programming languages to set up ... automation. Workbook automation via SQL SQL users can set up automation using a simple preprocessor syntax. Workbook automation via.NET (model-binding) Developers can automate workbooks using C# and/or VB.NET ...

Customer Testimonial: a week, using QueryStorm to write SQL queries to transform the data. Pedrag Petrovic, Head of IT, Construction ...

Release Notes: with [System.ComponentModel.DisplayName("some name")] to control the display name of headers in results and when writing to Excel. Working with cells: Large speed improvements when working with cells both from C# and SQL. SQLite can now ...