This is major release (still in alpha), but fundamental portions of the engine have been changed. This is the final part of a two-part push to overhaul the parser (previous release) and now the schema-intersection-engine. The only outstanding issue is reimplementing stored procedures, but we really want to take some time and think that out. Other than that, we are now focused on validating the functionality of all features.

Engine

• Rewrite of schema intersection processor, now with more parallelism and vastly improved speed and maintainability.
• Added support for UPDATE with joins.
• Added support for DELETE with joins.
• Added support for ORDER BY using expressions and scalar/aggregate functions.
• Moved parser to dedicated library.
• Memory manager now released LOH object for greatly enhanced memory management.
• Added function descriptions to engine prototypes.
• Fixes to parsing negative numeric values.
• Added CountDistinct()
• Removed batch splitting on "GO", parser now knows where queries begin.
• Standardized all exceptions.
• Added new system function: ShowThreadPools

UI

• Now allows for more than one server connection.
• Incorporates schema awareness using lazy-loading for validation while writing queries.
• Static analyzer using new dedicated parsing library provides query-text insights in real-time.
• Code folding for comments and regions using --region "text" and --endregion.
• Font and font size can now be modified.
• Setting dialog now provides more customizability.

Full Changelog: https://github.com/NTDLS/Katzebase/compare/0.21.0...0.22.0