V1.1.3

Core libraries:

• Column headers are correctly trimmed when loading CSV files
• 'take' operator can now be used on materialized results
• TableBuilder now guarantees unique,non-blank column names
• Fixed bug in summarization of unions
• Excel file support for load/save

Lokqldx:

• csvdata command now renamed to 'addtable'
• results can now be saved to powerpoint presentations
• Simple powerpoint report generation tutorial added
• pivotColumnsToRows and pivotRowsToColumns commands added
• Excel files support including loadexcel command that loads multiple tables from a workbook
• Datagrid no longer swallows underscores in column names
• Fix issue where macros specified in workspace options were not run on workspace load

v1.1.2

• Improve error message for unimplemented query operators
• Support for pagination of KustoQueryResults
• Fix bug in handling of functions that consume/generate jsonarrays
• Implement top operator
• Add 'search' capability for lokqldx query editor
• lokqldx now auto-detects separator for csv files
• lokqldx correctly serialised splitter positions
• Additional kql functions supported

V1.1.1

Adds a few minor KQL builtins
Better workspace management in LokqlDx

v1.1.0

IMPORTANT It appears some dependencies are missing in the Powershell modules in this release. If you are dowloading in order to install edit-kql/pskql.dll please use 1.0.9 or wait for 1.1.1

What's Changed

• Switch to AvalonEdit for intellisense/autocomplete and syntax highlighting
• Add ability to generate powerpoint reports
• Add stored result concept
• Misc improvements to UI

Full Changelog: v1.0.9...v1.1.0

v1.0.9

Update to latest dependencies including Parquet.Net V5

v1.0.8

Updates dependencies
Adds new string functions (substring overload and padleft/padright)

What's Changed

• Strcat by @NeilMacMullen in #58
• • Update nuget dependencies by @NeilMacMullen in #59

Full Changelog: v1.0.7...v1.0.8

v1.0.7

What's Changed

• Allow specification of separator when loading csv files
• Prevent type inferrer treating long strings of digits as numbers and turning them into floating point
• Allow CSV serializer to load csvs without header-row
• Better support for hex numbers - implement parsehex and tohex
• More consistent use of UTC in dateTime functions

Full Changelog: v1.0.6...v1.0.7

v1.0.6

What's Changed

• Serialization improvements by @NeilMacMullen in #47
• upgrade nuget packages by @NeilMacMullen in #48
• Allow summarize by to list up to 10 properties by @NeilMacMullen in #49
• Improve edit-kql by supporting more property types by @NeilMacMullen in #50

Full Changelog: v1.0.5...v1.0.6

V1.0.5

What's Changed

• Lokqldx - Improve datagrid behaviour by @NeilMacMullen in #37
• Support skipheaderonsave by @NeilMacMullen in #38
• Improve interpolation by @NeilMacMullen in #39
• Update to latest Kusto Language version by @NeilMacMullen in #40
• Implement datetime_diff by @NeilMacMullen in #41
• Misc built-in function fixes by @NeilMacMullen in #42
• Provide experimental copilot support by @NeilMacMullen in #43
• Editkql by @NeilMacMullen in #45

Full Changelog: v1.0.4...v1.0.5

V1.0.4

Improvements to lokqldx

• Add icon and jumplist
• Add ability to fetch ApplicationInsights logs
• Add macro capability
• Fix a few minor presentation issues