Skip to content

2.2.0

Choose a tag to compare

@stevehansen stevehansen released this 26 Feb 05:51
· 34 commits to main since this release
00bd32e

What's New

Features

  • Derived table flattening — New FlattenDerivedTables option that removes unnecessary subquery wrappers after inlining
    • Phase 1: Single-table inner queries
    • Phase 2: Multi-table (JOIN) inner queries
    • Preserves derived table aliases on flattened single-table queries
  • JSON config file — New sqlinliner.json config file support with --config option
  • Join stripping for derived tables — Extended join stripping to handle inline subqueries
  • Persisted options — InlinerOptions stored in metadata comment and restored in optimize wizard
  • Benchmark improvements — HTML benchmark report, per-table IO breakdown, execution plan capture

Bug Fixes

  • Fix benchmark returning 0ms by flushing TDS messages and forcing English locale
  • Add warmup run before benchmark for fair cache comparison
  • Traverse UnqualifiedJoin (CROSS/OUTER APPLY) subtrees in flattener
  • Merge inner WHERE into JOIN ON clause instead of outer WHERE
  • Rewrite GROUP BY/HAVING refs and qualify unqualified columns in flattener
  • Resolve nullable compiler warnings in DatabaseConnection
  • Apply config file options as defaults in the optimize wizard
  • Wire FlattenDerivedTables into the optimize wizard
  • Fix no-args crash