Skip to content

v1.64.0

Choose a tag to compare

View all tags
@github-actions github-actions released this 01 Nov 18:21
· 84 commits to main since this release
v1.64.0
155178a

SQL CLI v1.64.0

Release Date: November 01, 2025

📊 Release Overview

  • Commits in this release: 37
  • Files updated: 113

✨ Highlights

🎨 Visual Improvements

🔍 Enhanced Debugging

  • Better Diagnostics: Improved error messages and state dumps

🏗️ Architecture Improvements

  • State Management: Continued migration to centralized AppStateContainer
  • Code Quality: Transaction-like state updates for better consistency

📝 Changes by Category

🚀 New Features

  • Add \st keymap for SQL transformation pipeline debug
  • Add QUALIFY clause support for window function filtering
  • Add ORDER BY expression support with aggregate transformer
  • Add transformer debugging with --show-transformations flag
  • Complete Phase 3 of Execution Mode Unification
  • Complete Phase 2 of execution mode unification
  • Complete Phase 1 of execution mode unification
  • Add unified execution module foundation (Phase 0)
  • Improve test output to clearly show JSON validation
  • Add data file hint support to examples test framework
  • Add examples test suite to CI pipeline
  • Add correlated subquery analyzer (Phase 1 - Detection)
  • Enable preprocessing pipeline in script execution (Quick Win #4)
  • Add GROUP BY clause alias expansion (Quick Win #3)
  • Add WHERE clause alias expansion (Quick Win #2)
  • Add HAVING auto-aliasing transformer (Quick Win #1)
  • Add AST preprocessing pipeline infrastructure (Phase 0)

🐛 Bug Fixes

  • Restore temp table persistence in --execute-statement mode
  • Change transformations keymap from \st to \sz
  • Add actual UNION ALL subquery example
  • Enable transformers in dependency-aware execution mode
  • Resolve qualified names regression and add transformer debugging
  • Make preprocessing pipeline run by default

🔧 Refactoring

  • Use Python examples test runner in run_all_tests.sh

📚 Documentation

  • Update roadmap with ORDER BY completion
  • Add UNION ALL subquery examples
  • Add ORDER BY expressions example file
  • Update CLAUDE.md with examples test framework commands
📋 View all commits
  • chore: Bump version to 1.64.0 and update CHANGELOG (TimelordUK)
  • fix: Restore temp table persistence in --execute-statement mode (TimelordUK)
  • fix(nvim): Change transformations keymap from \st to \sz (TimelordUK)
  • feat(nvim): Add \st keymap for SQL transformation pipeline debug (TimelordUK)
  • feat: Add QUALIFY clause support for window function filtering (TimelordUK)
  • docs: Update roadmap with ORDER BY completion (TimelordUK)
  • fix: Add actual UNION ALL subquery example (TimelordUK)
  • docs: Add UNION ALL subquery examples (TimelordUK)
  • test: Add formal test for ORDER BY expressions example (TimelordUK)
  • fix: Enable transformers in dependency-aware execution mode (TimelordUK)
  • docs: Add ORDER BY expressions example file (TimelordUK)
  • feat: Add ORDER BY expression support with aggregate transformer (TimelordUK)
  • feat: Add transformer debugging with --show-transformations flag (TimelordUK)
  • feat: Complete Phase 3 of Execution Mode Unification (TimelordUK)
  • feat: Complete Phase 2 of execution mode unification (TimelordUK)
  • feat: Complete Phase 1 of execution mode unification (TimelordUK)
  • more formal test captures (TimelordUK)
  • feat: Add unified execution module foundation (Phase 0) (TimelordUK)
  • examples and how to generate time series data (TimelordUK)
  • expectation tests (TimelordUK)
  • more expectations for examples (TimelordUK)
  • feat: Improve test output to clearly show JSON validation (TimelordUK)
  • feat: Add data file hint support to examples test framework (TimelordUK)
  • docs: Update CLAUDE.md with examples test framework commands (TimelordUK)
  • refactor: Use Python examples test runner in run_all_tests.sh (TimelordUK)
  • feat: Add examples test suite to CI pipeline (TimelordUK)
  • fix: Resolve qualified names regression and add transformer debugging (TimelordUK)
  • feat: Add correlated subquery analyzer (Phase 1 - Detection) (TimelordUK)
  • feat: Enable preprocessing pipeline in script execution (Quick Win #4) (TimelordUK)
  • test: Ignore test_orchestrator_preserves_original requiring history file (TimelordUK)
  • feat: Add GROUP BY clause alias expansion (Quick Win #3) (TimelordUK)
  • feat: Add WHERE clause alias expansion (Quick Win #2) (TimelordUK)
  • sql demo using bit string math add to readme (TimelordUK)
  • format (TimelordUK)
  • fix: Make preprocessing pipeline run by default (TimelordUK)
  • feat: Add HAVING auto-aliasing transformer (Quick Win #1) (TimelordUK)
  • feat: Add AST preprocessing pipeline infrastructure (Phase 0) (TimelordUK)

🎯 Key Features

  • Instant Data Preview: CSV/JSON files load immediately
  • Visual Feedback: Key press indicator, cell highlighting
  • Advanced Navigation: Vim-style keys, viewport/cursor lock
  • Powerful Search: Regular search (Ctrl+F), fuzzy filter (Ctrl+/)
  • Data Export: Save as CSV or JSON
  • Debug Mode: Press F5 for comprehensive state information

📦 Installation

Download the binary for your platform from the assets below.

Thank you for using SQL CLI! 🎉

Report issues: GitHub Issues

Assets 6
Loading