v1.66.0

SQL CLI v1.66.0

Release Date: November 02, 2025

📊 Release Overview

• Commits in this release: 12
• Files updated: 42

✨ Highlights

🔍 Enhanced Debugging

• Better Diagnostics: Improved error messages and state dumps

📝 Changes by Category

🚀 New Features

• Add SELECT * EXCLUDE syntax support (DuckDB compatibility)
• Add complete line geometry analysis toolkit
• Add comprehensive vector mathematics support
• Add ILIKE operator support (PostgreSQL compatibility)

🐛 Bug Fixes

• Fix test_examples.py capture for multi-statement JSON output
• Remove REPLACE keyword to avoid conflict with REPLACE() function

📚 Documentation

• Update roadmap to reflect completed features
• Add temp table example to README showing multi-stage -q queries

📋 View all commits

• chore: Bump version to 1.66.0 and update CHANGELOG (TimelordUK)
• fix: Fix test_examples.py capture for multi-statement JSON output (TimelordUK)
• test: Add formal test for SELECT * EXCLUDE feature (TimelordUK)
• feat: Add SELECT * EXCLUDE syntax support (DuckDB compatibility) (TimelordUK)
• feat(sql): Add complete line geometry analysis toolkit (TimelordUK)
• feat(sql): Add comprehensive vector mathematics support (TimelordUK)
• ci: Add performance benchmarking to GitHub Actions workflow (TimelordUK)
• fix: Remove REPLACE keyword to avoid conflict with REPLACE() function (TimelordUK)
• chore: Add EXCLUDE and REPLACE tokens to lexer (TimelordUK)
• feat: Add ILIKE operator support (PostgreSQL compatibility) (TimelordUK)
• docs: Update roadmap to reflect completed features (TimelordUK)
• docs: Add temp table example to README showing multi-stage -q queries (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

v1.64.0

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

v1.63.0

SQL CLI v1.63.0

Release Date: October 25, 2025

📊 Release Overview

• Commits in this release: 7
• Files updated: 23

✨ Highlights

🎨 Visual Improvements

📝 Changes by Category

🚀 New Features

• Add JOIN expression support Phase 2 - LEFT side expressions (v1.63.0)
• Improve demo script with --execute-statement support
• Add colorful number classification demos with ANSI colors

🐛 Bug Fixes

• Correct ANSI alignment in --execute-statement table output
• Correct table column alignment with ANSI color codes

📚 Documentation

• Add command examples to README screenshot captions

📋 View all commits

• demos (TimelordUK)
• feat: Add JOIN expression support Phase 2 - LEFT side expressions (v1.63.0) (TimelordUK)
• fix: Correct ANSI alignment in --execute-statement table output (TimelordUK)
• feat: Improve demo script with --execute-statement support (TimelordUK)
• docs: Add command examples to README screenshot captions (TimelordUK)
• feat: Add colorful number classification demos with ANSI colors (TimelordUK)
• fix: Correct table column alignment with ANSI color codes (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

v1.62.0

SQL CLI v1.62.0

Release Date: October 22, 2025

📊 Release Overview

• Commits in this release: 24
• Files updated: 66

✨ Highlights

🎨 Visual Improvements

🔍 Enhanced Debugging

• Better Diagnostics: Improved error messages and state dumps

📝 Changes by Category

🚀 New Features

• v1.62.0 - JOIN expression support & scoped star expansion
• Add test CSV files for scoped expansion examples
• Implement scoped table star expansion (SELECT table.*)
• Add vibrant gradient ASCII art showcase to README
• Complete comment preservation for SQL formatter with CTE support
• Add Flask + Kerberos Docker example with auto-renewal
• Add parser support for qualified star (table.*) syntax (Phase 1)
• Add helpful error for aggregate functions in HAVING clause
• Improve error messages for reserved keyword collisions
• Add opt-in ParserMode for comment preservation (Phase 2)
• Add ANSI terminal color and formatting functions
• Add file-level variable substitution with @set syntax

🐛 Bug Fixes

• Strip cache and diagnostic messages from exports
• Export only the focused table in multi-table results
• Apply @set variable substitution in \sE (expand SELECT *)

📚 Documentation

• Deep analysis of HAVING clause support and limitations
• Add comprehensive CROSS JOIN examples and documentation
• Add glorious rainbow color showcase to README 🌈

📋 View all commits

• feat: v1.62.0 - JOIN expression support & scoped star expansion (TimelordUK)
• format (TimelordUK)
• test: Add automated tests for scoped table star expansion (TimelordUK)
• feat(data): Add test CSV files for scoped expansion examples (TimelordUK)
• feat(sql): Implement scoped table star expansion (SELECT table.*) (TimelordUK)
• feat(docs): Add vibrant gradient ASCII art showcase to README (TimelordUK)
• feat: Complete comment preservation for SQL formatter with CTE support (TimelordUK)
• feat: Add Flask + Kerberos Docker example with auto-renewal (TimelordUK)
• test: Update Python test to use HAVING alias pattern (TimelordUK)
• test: Update integration tests to use HAVING alias pattern (TimelordUK)
• fix(nvim): Strip cache and diagnostic messages from exports (TimelordUK)
• test: Fix HAVING clause test to use alias pattern (TimelordUK)
• feat: Add parser support for qualified star (table.*) syntax (Phase 1) (TimelordUK)
• fix(nvim): Export only the focused table in multi-table results (TimelordUK)
• fix(nvim): Apply @set variable substitution in \sE (expand SELECT *) (TimelordUK)
• feat: Add helpful error for aggregate functions in HAVING clause (TimelordUK)
• docs: Deep analysis of HAVING clause support and limitations (TimelordUK)
• feat: Improve error messages for reserved keyword collisions (TimelordUK)
• docs: Add comprehensive CROSS JOIN examples and documentation (TimelordUK)
• feat: Add opt-in ParserMode for comment preservation (Phase 2) (TimelordUK)
• add more examples (TimelordUK)
• docs: Add glorious rainbow color showcase to README 🌈 (TimelordUK)
• feat(sql): Add ANSI terminal color and formatting functions (TimelordUK)
• feat(nvim): Add file-level variable substitution with @set syntax (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

v1.61.0

SQL CLI v1.61.0

Release Date: October 18, 2025

📊 Release Overview

• Commits in this release: 15
• Files updated: 49

✨ Highlights

🎨 Visual Improvements

🔍 Enhanced Debugging

• Better Diagnostics: Improved error messages and state dumps

📝 Changes by Category

🚀 New Features

• Make fuzzy filter interactive with navigation and lock mode
• Add opt-in comment preservation foundation (Phase 1)
• Add dependency-aware column expansion for \sX with temp tables
• Add terminal colored table output with YAML style configuration

🐛 Bug Fixes

• Exit insert mode and add persistent ESC handler for locked filters
• Fuzzy filter now filters currently focused table, not first table
• Remove cursor jump when navigating between tables with \sTn
• Improve table navigation UX with nearest table and smooth scrolling
• Fix line number mapping in --get-columns-at for \sE expansion
• Execute target statement to get schema in --get-columns-at

📋 View all commits

• chore: Bump version to 1.61.0 with Neovim plugin UX improvements (TimelordUK)
• fix(nvim): Exit insert mode and add persistent ESC handler for locked filters (TimelordUK)
• feat(nvim): Make fuzzy filter interactive with navigation and lock mode (TimelordUK)
• fix(nvim): Fuzzy filter now filters currently focused table, not first table (TimelordUK)
• fix(nvim): Remove cursor jump when navigating between tables with \sTn (TimelordUK)
• fix(nvim): Improve table navigation UX with nearest table and smooth scrolling (TimelordUK)
• feat: Add opt-in comment preservation foundation (Phase 1) (TimelordUK)
• fix: Fix line number mapping in --get-columns-at for \sE expansion (TimelordUK)
• format (TimelordUK)
• fix: Execute target statement to get schema in --get-columns-at (TimelordUK)
• feat: Add dependency-aware column expansion for \sX with temp tables (TimelordUK)
• correct README (TimelordUK)
• move test files from root (TimelordUK)
• styled example (TimelordUK)
• feat: Add terminal colored table output with YAML style configuration (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

v1.60.0

SQL CLI v1.60.0

Release Date: October 12, 2025

📊 Release Overview

• Commits in this release: 30
• Files updated: 39

✨ Highlights

🔍 Enhanced Debugging

• Better Diagnostics: Improved error messages and state dumps

📝 Changes by Category

🚀 New Features

• Add comprehensive hedge fund execution analysis example
• Add FIX execution endpoint to mock API server
• Add dependency-aware statement execution for scripts
• Add PI_DIGIT(n) function for Nth decimal digit lookup
• Add PI_DIGITS() function for arbitrary precision π
• Add script dependency analyzer for temp table tracking

🐛 Bug Fixes

• Register temp tables after executing INTO statements
• Fix statement counting and case-insensitive GO matching for \sx
• Correct statement number counting in Neovim plugin for dependency-aware execution
• Support alternative SQL Server INTO syntax and refactor to AST-based dependency analysis
• Only show 'rows affected' message for table output format
• Add missing ColumnRef import in window_functions/mod.rs

🔧 Refactoring

• Extract classic console mode to function (~98 lines)
• Extract key debugger and config generation handlers (115 lines)
• Create argument parsing context object (Python argparse style)
• Extract non-interactive query mode to local function (132 lines removed)
• Extract schema handlers to main_handlers.rs (174 lines removed)
• Extract benchmark handler to main_handlers.rs (87 lines removed)
• Extract distinct column handler to main_handlers.rs (113 lines removed)
• Extract documentation handlers to main_handlers.rs (255 lines removed)
• Extract handler functions from main() (92 lines removed)
• Extract CLI handlers to organized cli module (299 lines removed from main.rs)

📚 Documentation

• Move WEB CTE temp tables test to examples with ABS demo
• Add π digits example to README showcasing RANGE query
• Add --execute-statement feature plan

📋 View all commits

• chore: Bump version to 1.60.0 (TimelordUK)
• feat: Add comprehensive hedge fund execution analysis example (TimelordUK)
• feat: Add FIX execution endpoint to mock API server (TimelordUK)
• docs: Move WEB CTE temp tables test to examples with ABS demo (TimelordUK)
• test: Add WEB CTE with temp tables integration test (TimelordUK)
• fix: Register temp tables after executing INTO statements (TimelordUK)
• fix: Fix statement counting and case-insensitive GO matching for \sx (TimelordUK)
• fix: Correct statement number counting in Neovim plugin for dependency-aware execution (TimelordUK)
• fix: Support alternative SQL Server INTO syntax and refactor to AST-based dependency analysis (TimelordUK)
• feat: Add dependency-aware statement execution for scripts (TimelordUK)
• refactor: Extract classic console mode to function (~98 lines) (TimelordUK)
• refactor: Extract key debugger and config generation handlers (115 lines) (TimelordUK)
• add a temp chart examples (TimelordUK)
• first 10k places of PI and find nth place of pi (TimelordUK)
• docs: Add π digits example to README showcasing RANGE query (TimelordUK)
• feat: Add PI_DIGIT(n) function for Nth decimal digit lookup (TimelordUK)
• feat: Add PI_DIGITS() function for arbitrary precision π (TimelordUK)
• add prime examples (TimelordUK)
• docs: Add --execute-statement feature plan (TimelordUK)
• refactor: Create argument parsing context object (Python argparse style) (TimelordUK)
• refactor: Extract non-interactive query mode to local function (132 lines removed) (TimelordUK)
• refactor: Extract schema handlers to main_handlers.rs (174 lines removed) (TimelordUK)
• refactor: Extract benchmark handler to main_handlers.rs (87 lines removed) (TimelordUK)
• refactor: Extract distinct column handler to main_handlers.rs (113 lines removed) (TimelordUK)
• refactor: Extract documentation handlers to main_handlers.rs (255 lines removed) (TimelordUK)
• refactor: Extract handler functions from main() (92 lines removed) (TimelordUK)
• refactor: Extract CLI handlers to organized cli module (299 lines removed from main.rs) (TimelordUK)
• feat: Add script dependency analyzer for temp table tracking (TimelordUK)
• fix: Only show 'rows affected' message for table output format (TimelordUK)
• fix: Add missing ColumnRef import in window_functions/mod.rs (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

v1.59.0

SQL CLI v1.59.0

Release Date: October 11, 2025

📊 Release Overview

• Commits in this release: 13
• Files updated: 27

✨ Highlights

🔍 Enhanced Debugging

• Better Diagnostics: Improved error messages and state dumps

📝 Changes by Category

🚀 New Features

• Add comment-aware tokenization foundation
• Add UNION (with deduplication) support
• Add UNION ALL support for combining SELECT query results

🐛 Bug Fixes

• Correct SELECT INTO syntax in tmp_table.sql example
• Support SELECT INTO #temp formatting
• Restore normal buffer navigation after toggling out of table mode

🔧 Refactoring

• Replace regex-based INTO removal with AST preprocessing

📚 Documentation

• Mark CODE CTE feature as not proceeding
• Add session summary for 2025-01-11 CODE CTE investigation
• Add lexer and parser considerations analysis
• Add CODE CTE design document for programmable data transformations

📋 View all commits

• chore: Bump version to v1.59.0 (TimelordUK)
• perf: Fix 23x performance regression in WHERE clause evaluation (TimelordUK)
• feat: Add comment-aware tokenization foundation (TimelordUK)
• refactor: Replace regex-based INTO removal with AST preprocessing (TimelordUK)
• fix: Correct SELECT INTO syntax in tmp_table.sql example (TimelordUK)
• fix: Support SELECT INTO #temp formatting (TimelordUK)
• fix: Restore normal buffer navigation after toggling out of table mode (TimelordUK)
• feat: Add UNION (with deduplication) support (TimelordUK)
• feat: Add UNION ALL support for combining SELECT query results (TimelordUK)
• docs: Mark CODE CTE feature as not proceeding (TimelordUK)
• docs: Add session summary for 2025-01-11 CODE CTE investigation (TimelordUK)
• docs: Add lexer and parser considerations analysis (TimelordUK)
• docs: Add CODE CTE design document for programmable data transformations (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

v1.58.0

SQL CLI v1.58.0

Release Date: October 09, 2025

📊 Release Overview

• Commits in this release: 14
• Files updated: 32

✨ Highlights

🔍 Enhanced Debugging

• Better Diagnostics: Improved error messages and state dumps

📝 Changes by Category

🚀 New Features

• Phase 5 - Add ORDER BY alias resolution
• Phase 4 - Fix SELECT clause alias resolution
• Phase 3 - Fix WHERE clause alias resolution
• Phase 2 - Add unified resolve_column helper
• Phase 1 - Add ExecutionContext for table alias tracking
• Enable CTEs to reference temp tables
• Implement Phase 2A - Template injection for WEB CTEs
• Add EXIT and [SKIP] directives for script control
• Implement temporary tables (#tmp) for script execution

📚 Documentation

• Add comprehensive qualified names example

📋 View all commits

• chore: Release v1.58.0 - Qualified Column Names and Table Alias Support (TimelordUK)
• test remove from auto runner (TimelordUK)
• docs: Add comprehensive qualified names example (TimelordUK)
• feat: Phase 5 - Add ORDER BY alias resolution (TimelordUK)
• feat: Phase 4 - Fix SELECT clause alias resolution (TimelordUK)
• feat: Phase 3 - Fix WHERE clause alias resolution (TimelordUK)
• feat: Phase 2 - Add unified resolve_column helper (TimelordUK)
• feat: Phase 1 - Add ExecutionContext for table alias tracking (TimelordUK)
• feat: Enable CTEs to reference temp tables (TimelordUK)
• format (TimelordUK)
• feat: Implement Phase 2A - Template injection for WEB CTEs (TimelordUK)
• feat: Add EXIT and [SKIP] directives for script control (TimelordUK)
• feat: Implement temporary tables (#tmp) for script execution (TimelordUK)
• start on tmp table implementation. (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

v1.57.1

SQL CLI v1.57.1

Release Date: October 06, 2025

📊 Release Overview

• Commits in this release: 36
• Files updated: 103

✨ Highlights

🎨 Visual Improvements

🔍 Enhanced Debugging

• Better Diagnostics: Improved error messages and state dumps

📝 Changes by Category

🚀 New Features

• Add flexible date parsing functions and improve Nvim plugin UX
• Add FIX Protocol timestamp support and millisecond precision
• Implement UNNEST row expansion for delimited strings
• Add isolated row expansion system with UNNEST implementation
• Add UNNEST parser support and test data for FIX allocations
• Add UNNEST foundation - AST, lexer, and formatter support
• Add FIX timestamp, currency codes, and PendingCancel status highlighting
• Enhanced FIX message syntax highlighting with case-insensitive matching
• Add FIX message syntax highlighting examples for nvim plugin
• Add configurable table styles and custom syntax highlighting
• Add --cache-purge flag for easy cache management
• Complete data model navigation with Neovim-native scrolling
• Add data model architecture for structured query results
• Add raw query analysis JSON viewer (\sJ)
• Add CACHE, FORM_FILE, and FORM_FIELD support to CTE extraction
• Add CLI analysis foundation + CTE Tester V3

🐛 Bug Fixes

• Cache purge pattern - use sql-cli: instead of sql_cli:
• Cache purge command path and which-key discoverability
• Complete CTE extraction improvements for WEB CTEs
• Correct WEB CTE HEADERS syntax (colon + commas)
• Extract ALL CTEs up to target for executable queries

🔧 Refactoring

• Use jq for JSON pretty printing if available
• Remove old CTE tester versions and consolidate to CLI-based analysis
• Unify expression formatting to eliminate code duplication

📚 Documentation

• Add comprehensive UNNEST performance analysis
• Add UNNEST examples with FIX allocations demo
• Add comprehensive UNNEST implementation guide
• Add project summary and overview
• Add plugin data model evolution architecture
• Add START_HERE guide for new contributors
• Organize documentation and create 2025 roadmap

📋 View all commits

• feat: Add flexible date parsing functions and improve Nvim plugin UX (TimelordUK)
• fix test showing delta with lag (TimelordUK)
• feat: Add FIX Protocol timestamp support and millisecond precision (TimelordUK)
• docs: Add comprehensive UNNEST performance analysis (TimelordUK)
• docs: Add UNNEST examples with FIX allocations demo (TimelordUK)
• feat: Implement UNNEST row expansion for delimited strings (TimelordUK)
• docs: Add comprehensive UNNEST implementation guide (TimelordUK)
• feat: Add isolated row expansion system with UNNEST implementation (TimelordUK)
• feat: Add UNNEST parser support and test data for FIX allocations (TimelordUK)
• feat: Add UNNEST foundation - AST, lexer, and formatter support (TimelordUK)
• feat: Add FIX timestamp, currency codes, and PendingCancel status highlighting (TimelordUK)
• feat: Enhanced FIX message syntax highlighting with case-insensitive matching (TimelordUK)
• color syntax for fix (TimelordUK)
• feat: Add FIX message syntax highlighting examples for nvim plugin (TimelordUK)
• fix: Cache purge pattern - use sql-cli: instead of sql_cli: (TimelordUK)
• fix: Cache purge command path and which-key discoverability (TimelordUK)
• feat: Add configurable table styles and custom syntax highlighting (TimelordUK)
• feat: Add --cache-purge flag for easy cache management (TimelordUK)
• revert: Remove data model architecture - return to text-based navigation (TimelordUK)
• feat: Complete data model navigation with Neovim-native scrolling (TimelordUK)
• feat: Add data model architecture for structured query results (TimelordUK)
• refactor: Use jq for JSON pretty printing if available (TimelordUK)
• feat: Add raw query analysis JSON viewer (\sJ) (TimelordUK)
• refactor: Remove old CTE tester versions and consolidate to CLI-based analysis (TimelordUK)
• feat: Add CACHE, FORM_FILE, and FORM_FIELD support to CTE extraction (TimelordUK)
• refactor: Unify expression formatting to eliminate code duplication (TimelordUK)
• fix: Complete CTE extraction improvements for WEB CTEs (TimelordUK)
• fix: Correct WEB CTE HEADERS syntax (colon + commas) (TimelordUK)
• fix: Extract ALL CTEs up to target for executable queries (TimelordUK)
• feat: Add CLI analysis foundation + CTE Tester V3 (TimelordUK)
• fitlering functions (TimelordUK)
• fix example tester (TimelordUK)
• docs: Add project summary and overview (TimelordUK)
• docs: Add plugin data model evolution architecture (TimelordUK)
• docs: Add START_HERE guide for new contributors (TimelordUK)
• docs: Organize documentation and create 2025 roadmap (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

v1.56.0

SQL CLI v1.56.0

Release Date: October 02, 2025

📊 Release Overview

• Commits in this release: 63
• Files updated: 173

✨ Highlights

🎨 Visual Improvements

🔍 Enhanced Debugging

• Better Diagnostics: Improved error messages and state dumps

💾 Data Protection

• History Recovery: Automatic recovery from corrupted files
• Atomic Writes: Safer file operations to prevent data loss

📝 Changes by Category

🚀 New Features

• Add smart column expansion and distinct values analysis
• Add auto_hide_empty option to table_output config
• Add configurable column width and sampling for table output
• Add yank column as JSON array for WEB CTE workflow
• Add JSON pretty-printing for WEB CTE BODY clause
• Add format.sql example for testing JSON pretty-printing in WEB CTEs
• Add column sum/statistics calculator
• Add Telescope-style fuzzy filter for SQL results
• Add multi-token JWT management system
• Add statusline integration for token refresh notifications
• Add multi-token manager with auto-refresh support
• Add multi-token management system with refresh commands
• Add bitwise string manipulation functions
• Integrate Redis cache config into existing config system
• Add Redis cache management tools and nvim notifications
• Add opt-in Redis caching for Web CTEs
• Add execution and action hints to query history window titles
• Add preview pane scrolling for long queries in history UI
• Add persistence and import/export for query history
• Add direct execution from query history (x key)

🐛 Bug Fixes

• Remove SQL comments from CTE test queries
• Add WEB CTE support to query generation phase
• Rewrite CTE cursor detection logic to fix off-by-one bug
• Preserve $JSON$ delimiters in FORM_FIELD values
• Trim whitespace in column JSON array yank
• Add table navigation diagnostics and improve boundary handling
• Fix null exceptions and add layout reset recovery
• Preserve window function frames and add $JSON$ delimiter support
• Fix token corruption from multi-line script output
• Trim whitespace from tokens in multi_token_manager
• Use leader-based keybindings for fuzzy filter
• Fix parameter input handling for dynamic queries
• Improve parameter resolution for dynamic queries
• Make Web CTE caching independent of query context
• Fix Redis cache key collision for same-named Web CTEs
• Fix table navigation issues with query result boundaries
• Handle PowerShell execution policy restrictions
• Fix PowerShell token command path expansion
• Clean up Rust build warnings
• Prevent duplicate token refresh on startup
• Ensure cache messages always appear at top of output
• Simplify window switching in query history UI
• Prevent query history windows from closing when switching focus with Space
• Improve delete functionality in query history UI
• Separate interactive params {{}} from environment vars ${}
• Trim leading/trailing whitespace from query history entries
• Use execute_query instead of non-existent execute_buffer

🔧 Refactoring

• Clean up unused field warnings by prefixing with underscore

📚 Documentation

• Add development roadmap for next week's features
• Add Web CTE caching system design for next session

📋 View all commits

• chore: Bump version to 1.56.0 and update CHANGELOG (TimelordUK)
• feat(nvim): Add smart column expansion and distinct values analysis (TimelordUK)
• refactor: Clean up unused field warnings by prefixing with underscore (TimelordUK)
• new doc for HAVING_CTE_HOISTING (TimelordUK)
• feat(nvim): Add auto_hide_empty option to table_output config (TimelordUK)
• fix(nvim): Remove SQL comments from CTE test queries (TimelordUK)
• fix(nvim): Add WEB CTE support to query generation phase (TimelordUK)
• debug(nvim): Add verbose CTE search logging to diagnose WEB CTE detection (TimelordUK)
• fix(nvim): Rewrite CTE cursor detection logic to fix off-by-one bug (TimelordUK)
• debug(nvim): Add verbose cursor position debugging for CTE detection (TimelordUK)
• debug(nvim): Add SQL comment debug output to CTE tester (TimelordUK)
• feat: Add configurable column width and sampling for table output (TimelordUK)
• debug for cte tester (TimelordUK)
• fix(formatter): Preserve $JSON$ delimiters in FORM_FIELD values (TimelordUK)
• fix(nvim): Trim whitespace in column JSON array yank (TimelordUK)
• fix(nvim): Add table navigation diagnostics and improve boundary handling (TimelordUK)
• feat(nvim): Add yank column as JSON array for WEB CTE workflow (TimelordUK)
• fix(nvim): Fix null exceptions and add layout reset recovery (TimelordUK)
• fix(formatter): Preserve window function frames and add $JSON$ delimiter support (TimelordUK)
• fix(nvim): Fix token corruption from multi-line script output (TimelordUK)
• fix(nvim): Trim whitespace from tokens in multi_token_manager (TimelordUK)
• feat: Add JSON pretty-printing for WEB CTE BODY clause (TimelordUK)
• feat: Add format.sql example for testing JSON pretty-printing in WEB CTEs (TimelordUK)
• formatting (TimelordUK)
• feat(nvim): Add column sum/statistics calculator (TimelordUK)
• fix(nvim): Use leader-based keybindings for fuzzy filter (TimelordUK)
• feat(nvim): Add Telescope-style fuzzy filter for SQL results (TimelordUK)
• fix(nvim): Fix parameter input handling for dynamic queries (TimelordUK)
• fix(nvim): Improve parameter resolution for dynamic queries (TimelordUK)
• fix: Make Web CTE caching independent of query context (TimelordUK)
• fix: Fix Redis cache key collision for same-named Web CTEs (TimelordUK)
• fix(nvim): Fix table navigation issues with query result boundaries (TimelordUK)
• docs: Add development roadmap for next week's features (TimelordUK)
• add windows and linux working multi token config (TimelordUK)
• fix(nvim): Handle PowerShell execution policy restrictions (TimelordUK)
• fix(nvim): Fix PowerShell token command path expansion (TimelordUK)
• fix: Clean up Rust build warnings (TimelordUK)
• feat(nvim): Add multi-token JWT management system (TimelordUK)
• fix(nvim): Prevent duplicate token refresh on startup (TimelordUK)
• feat(nvim): Add statusline integration for token refresh notifications (TimelordUK)
• feat(nvim): Add multi-token manager with auto-refresh support (TimelordUK)
• feat: Add multi-token management system with refresh commands (TimelordUK)
• feat: Add bitwise string manipulation functions (TimelordUK)
• fix(nvim): Ensure cache messages always appear at top of output (TimelordUK)
• feat: Integrate Redis cache config into existing config system (TimelordUK)
• feat: Add Redis cache management tools and nvim notifications (TimelordUK)
• feat: Add opt-in Redis caching for Web CTEs (TimelordUK)
• add ascii art generator (TimelordUK)
• add a xml parser allowing cds data to be extracted into a flattened csv/json (TimelordUK)
• add swagger support (TimelordUK)
• move files from root (TimelordUK)
• feat: Add execution and action hints to query history window titles (TimelordUK)
• fix: Simplify window switching in query history UI (TimelordUK)
• fix: Prevent query history windows from closing when switching focus with Space (TimelordUK)
• feat: Add preview pane scrolling for long queries in history UI (TimelordUK)
• fix: Improve delete functionality in query history UI (TimelordUK)
• fix: Separate interactive params {{}} from environment vars ${} (TimelordUK)
• demo config lua for pluygin (TimelordUK)
• docs: Add Web CTE caching system design for next session (TimelordUK)
• feat: Add persistence and import/export for query history (TimelordUK)
• fix: Trim leading/trailing whitespace from query history entries (TimelordUK)
• fix: Use execute_query instead of non-existent execute_buffer (TimelordUK)
• feat: Add direct execution from query history (x key) (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