Core

• Add convert_ functions
• Allow case statements with up to 64 conditions (previously 10)
• Fix issue where "where false" would return table without columns.. Thanks to @FrodeHus
• Fix issue where projecting just a constant column would not generate the correctly number of rows. Thanks to @FrodeHus

Full Changelog: v1.5.0...v1.5.1

Core

• Fix up behaviour of "between" operator when using reals
• Fix bug in anti and semi joins when "on" column was at different index in left and right tables

Applications

• Add simple MCP server

Lokqldx

• Add command to create datatable expression from query result
• Add crashlogging

Core

• Implement with_index in mv-expand
• Add IPV6 support for geo_info_from_ip_address @akefallonitis
• fix issue with parsing real literals in non-english cultures

Lokqldx

• Allow up/down arrow to select items in search-recent-workspaces
• Fixup broken help links
• Add support for formatting KQL (ALT-SHIFT-F)
• Title bar now gives workspace name more prominence

Core

• Many new functions and operators implemented thanks to @akefallonitis...

  • bag_keys
  • bag_has_key
  • bag_remove_keys
  • bag_set_key
  • bag_zip
  • set_union
  • set_intersect
  • set_difference
  • set_has_element
  • ipv4_is_in_range
  • ipv4_is_in_any_range
  • ipv4_is_match
  • ipv4_compare
  • ipv4_lookup
  • format_ipv4
  • format_ipv4_mask
  • ipv4_netmask_suffix
  • parse_ipv4_mask
  • ipv4_range_to_cidr_list
  • has_ipv4
  • has_ipv4_prefix
  • has_any_ipv4
  • has_any_ipv4_prefix
  • parse_url
  • parse_urlquery
  • extract_all
  • geo_info_from_ip_address
  • parse_user_agent
  • mv-apply
  • externaldata
  • make-series

• parse_user_agent and geio_info_from_ip_address are supported via optional companion packages: KustoLoco.Geo (DB-IP) and KustoLoco.UserAgent

Lokqldx

• Improve load/save commands with extra options to allow specification of separators, column-type inference, and column-headers
• .exec command
• .loadgeoip and .loaduseragents commands allow loading of external database
• Menu shortcuts for font-size, line-numbers and word-wrap are restored
• New "search recent workspaces" dialog allows previous workspaces to be found more easily
• "new query" and "copy current query" menu commands added

Full Changelog: v1.4.7...v1.4.8

Core

• Fixed an issue where DateTimes imported from CSV or sources that required type inference did not use correct timezone
• Add additional unary minus overload for int promoted to long
• Add 'offset' implementations for startofX datetime functions

Lokqldx

• Port to Avalonia 12
• Add highlighting for additional keywords

Core

• Implement bag_merge and pack_all. Thanks to @cyril-iselin !

Special thanks to @EnsnerT and @cyril-iselin for bug reports and PRs ❤️ !

Core

• Dependency updates
• KustoQueryResult.ToRecords now supports readonly record structs
• Fix % operator for Timespan
• Implement %(DateTime,Timespan)
• Implement unix_time, net_time convenience functions
• sixel chart size can now be controlled with sixel.width/sixel.height
• implement bag-pack-variadic (thanks to @cyril-iselin )

Lokqldx (UI)

• Syntax highlighting for distinct and lookup
• Fix crash on column charts when only one column provided
• noheader flag is obeyed when saving text files
• Fix crash on multi-select and allow copy of multiple selected cells to clipboard

Lokql (CLI)

• Reset console colors on clean exit
• "interactive" and "run" commands now use consistent parameters
  • args parameter allows passing of arguments named arg0, arg1 etc
  • commands parameter allows one or more query statements/commands to be executed
  • scripts parameter allows one or more scripts to be loaded and run
  • load parameter allows files to be loaded as tables
• convert command can be used to load a file in one format and save it in another

Core

• Fix min/max aggration type for ints
• Improve ToRecords implementation

LokqlDx

• Add dcount syntax highlighting
• add .cd and .lsfiles commands
• Significant improvements to copilot mode

What's Changed

• Add basic label capability to maps by @NeilMacMullen in #550
• Add copilot view

Full Changelog: v1.4.2...v1.4.3

Core

• Nuget packages now multitarget .net9 and .net10
• Support mv-expand with multiple columns and nested dynamic paths by @Arithmomaniac
• Add parse_ipv4 and parse_ipv6 functions by @Arithmomaniac
• Support requestedIndex parameter of split function by @Arithmomaniac
• Add buildschema, make_bag, and make_bag_if aggregation functions by @Arithmomaniac
• Move source-generator attributes to KustoLoco.Core package by @NeilMacMullen

LokqlDx

• Allow CTRL-C and related keystrokes to copy from datagrid by @NeilMacMullen
• Add a context menu to map to allow opening in google by @NeilMacMullen
• Now targets .net10 by @NeilMacMullen
• Fix deadlock/timing issue on release by @NeilMacMullen

Full Changelog: v1.4.1...v1.4.2