Skip to content

LPTS 1.0.0

Choose a tag to compare

@ila ila released this 23 Jun 12:27

LPTS 1.0.0 — first stable release.

Added

  • EXPLAIN (FORMAT SQL) <query> renders the optimized logical plan as equivalent CTE SQL (the same output as PRAGMA lpts), exposed as a genuine EXPLAIN statement. The CLI prints it as plain multi-line text; JDBC/Python and other clients receive the standard two-column explain_key/explain_value EXPLAIN result. Honors lpts_dialect. Implemented without changes to DuckDB core.

Changed

  • Generated SQL is now pretty-printed across multiple lines (instead of a single line), with HAVING fused into its aggregate and join build-side CTEs marked, for more readable output.
  • Fewer CTEs are emitted while keeping execution order unambiguous, and column names are now human-readable (e.g. t0_scan (t0_name)) rather than purely positional.
  • DuckDB target bumped from v1.5.3 to v1.5.4 (submodule and CI). The 1.5.4 optimizer pushes trivial projections/filters into the scan, so single-table plans may collapse to a plain SELECT with no separate projection CTE; round-trip correctness is unchanged.

Compatibility

  • DuckDB target: v1.5.4
  • extension-ci-tools target: v1.5-variegata