v1.1.4

What's Changed

Special thanks to contributors 🚀

• @DerekGooding for making the WPF processes demo look so much better 👀
• @KapiteinKrapBijKas for adding support for base64 encode/decode functions 🧑‍🔬
• @tbui17 for providing intellisense completion on file paths 📁

Core libraries:

• Base64 encode/decode functions (base64_encode_tostring and base64_decode_tostring)
• Parquet files with multiple rowgroups are now supported
• It's now possible to create contexts from DataTables and DataSets

Lokqldx

• Allow datetime format in datagrid to be set using setting
• minor tweak to title bar to improve taskbar display

• Comments are now more legible
• Pivot commands are now less confusing and provide a default tablename
• Much improved barchart rendering
• Add support for creating context from DataTable/DataSet by @NeilMacMullen in #157
• SHIFT-UP/DOWN can be used to navigate between query blocks

Full Changelog: v1.1.3...v1.1.4

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