v1.69.2

SQL CLI v1.69.2

Release Date: April 14, 2026

📊 Release Overview

• Commits in this release: 3
• Files updated: 2

✨ Highlights

🔍 Enhanced Debugging

• Better Diagnostics: Improved error messages and state dumps

📝 Changes by Category

🐛 Bug Fixes

• Case-insensitive CTE table resolution

📚 Documentation

• Move Unreleased DATEDIFF entry to v1.69.1
• Backfill CHANGELOG for v1.67.1 through v1.69.0

📋 View all commits

• fix(joins): Case-insensitive CTE table resolution (TimelordUK)
• docs: Move Unreleased DATEDIFF entry to v1.69.1 (TimelordUK)
• docs: Backfill CHANGELOG for v1.67.1 through v1.69.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.69.1

SQL CLI v1.69.1

Release Date: April 13, 2026

📊 Release Overview

• Commits in this release: 1
• Files updated: 1

✨ Highlights

📝 Changes by Category

🚀 New Features

• DATEDIFF accepts 2-arg MySQL style

📋 View all commits

• feat(functions): DATEDIFF accepts 2-arg MySQL style (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.69.0

SQL CLI v1.69.0

Release Date: April 13, 2026

📊 Release Overview

• Commits in this release: 4
• Files updated: 5

✨ Highlights

📝 Changes by Category

🚀 New Features

• add FORMAT_BYTES for human-readable byte sizes

🐛 Bug Fixes

• Allow aggregates in HAVING that aren't in SELECT

📋 View all commits

• fix(having): Allow aggregates in HAVING that aren't in SELECT (TimelordUK)
• format the file sizes (TimelordUK)
• add example of using format_byes on total bytes for a folder (TimelordUK)
• feat(functions): add FORMAT_BYTES for human-readable byte sizes (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.68.0

SQL CLI v1.68.0

Release Date: April 12, 2026

📊 Release Overview

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

✨ Highlights

🔍 Enhanced Debugging

• Better Diagnostics: Improved error messages and state dumps

📝 Changes by Category

🚀 New Features

• Boolean expressions in aggregates, unary minus, qualified PARTITION BY
• Implement FILE CTE filesystem walker

📋 View all commits

• feat: Boolean expressions in aggregates, unary minus, qualified PARTITION BY (TimelordUK)
• feat: Implement FILE CTE filesystem walker (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.67.2

SQL CLI v1.67.2

Release Date: April 12, 2026

📊 Release Overview

• Commits in this release: 2
• Files updated: 5

✨ Highlights

📝 Changes by Category

🚀 New Features

• add POPCOUNT, LEADING_ZEROS, TRAILING_ZEROS and polymorphic BIT_COUNT

🐛 Bug Fixes

• Wire up HelpWidget for tabbed, scrollable help pages

📋 View all commits

• fix(tui): Wire up HelpWidget for tabbed, scrollable help pages (TimelordUK)
• feat(functions): add POPCOUNT, LEADING_ZEROS, TRAILING_ZEROS and polymorphic BIT_COUNT (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.67.1

SQL CLI v1.67.1

Release Date: April 11, 2026

📊 Release Overview

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

✨ Highlights

🎨 Visual Improvements

• Key Press Indicator: Visual feedback for key presses with fade effects (F12 to toggle)

🔍 Enhanced Debugging

• Better Diagnostics: Improved error messages and state dumps

📝 Changes by Category

🚀 New Features

• Add FILE CTE parser scaffold (parser-only, execution stubbed)
• Migrate query execution to use unified from_source field - PIVOT now works end-to-end!
• Add PivotExpander transformer (Phase 4 - partial)
• Add PIVOT parser implementation
• Add PIVOT AST structures and pattern matching
• Add PIVOT/UNPIVOT lexer tokens and test data
• Implement SQL standard implicit window frames
• Make batch window evaluation the default and fix expression handling
• Optimize window aggregates for UNBOUNDED PRECEDING frames
• Implement batch evaluation for window functions - 86% performance improvement!
• Window function optimization Phase 2 + Step 0 prep for batch evaluation
• Add Phase 1 window function profiling infrastructure

🐛 Bug Fixes

• Set from_source in ExpressionLifter to fix QUALIFY regression
• Update Python tests to use assertions instead of return values

🔧 Refactoring

• Improve CTE handling in source table extraction
• Add unified from_source field to SelectStatement and integrate PIVOT expansion

📚 Documentation

• Document undocumented-but-working key bindings
• Remove F7/F12 from help — bindings don't fire at runtime
• Fix stale entries in native TUI help page
• Add comprehensive PIVOT examples with best practices

📊 Performance Benchmarks

Indicative numbers from uv run scripts/benchmark_all.py (release build, 3-run average, 1k → 50k rows) — use these to set expectations around the 50k–100k row mark, which is where most interactive sessions sit. Scaling is O(n) or better across the board, so 100k ≈ 2× the 50k figures below.

📈 Click to expand full benchmark results

Environment: AMD Ryzen 9 7950X · Linux (WSL2) · rustc 1.94.1 · release profile

🏆 Highlights at 50,000 rows

Fastest operations

#	Operation	Time
1	Simple SELECT * (LIMIT 100)	1.64 ms
2	Hash JOIN (equality) — small	3.33 ms
3	ORDER BY single column (LIMIT 100)	5.55 ms
4	Hash JOIN (equality) — medium	6.26 ms
5	JOIN with CTE categories	13.42 ms

Heaviest operations

#	Operation	Time
1	Multi-column GROUP BY	1.39 s
2	GROUP BY with multiple aggregates	1.03 s
3	Complex WHERE (3 conditions)	588.6 ms
4	LAG with PARTITION BY	505.4 ms
5	GROUP BY with SUM	441.8 ms

📋 Full results — 50,000 rows

Category	Operation	Time
Basic	Simple SELECT *	1.64 ms
	WHERE numeric comparison	160.6 ms
	WHERE string equality	262.4 ms
	Complex WHERE (3 conditions)	588.6 ms
	ORDER BY single column	5.55 ms
	ORDER BY multiple columns	14.28 ms
	COUNT(DISTINCT)	186.0 ms
LIKE	Suffix wildcard	170.0 ms
	Prefix wildcard	168.1 ms
	Both wildcards	219.7 ms
	Multiple LIKE conditions	331.6 ms
	LIKE with result set	172.8 ms
GROUP BY	Simple GROUP BY	261.0 ms
	GROUP BY + SUM	441.8 ms
	Multiple aggregates	1.03 s
	Multi-column GROUP BY	1.39 s
Window	LAG	394.3 ms
	LEAD	390.2 ms
	LAG + LEAD combined	427.5 ms
	LAG with PARTITION BY	505.4 ms
	ROW_NUMBER	382.7 ms
JOIN	Hash JOIN (equality) — small	3.33 ms
	Hash JOIN (equality) — medium	6.26 ms
	Nested loop JOIN (inequality)	71.30 ms
	Self-join cumulative sum	42.08 ms
	LEFT JOIN with inequality	72.22 ms
	JOIN with CTE categories	13.42 ms

🔬 Scaling analysis (1k → 50k rows)

Operation	Complexity
Simple SELECT *	✅ O(1) — constant
ORDER BY single column	✅ O(1) — constant
Hash JOIN (equality) — small	✅ O(1) — constant
Hash JOIN (equality) — medium	✅ O(1) — constant
ORDER BY multiple columns	🟢 O(log n)
Self-join for cumulative sum	🟢 O(log n)
JOIN with CTE categories	🟢 O(log n)
All WHERE filters	🔵 O(n) — linear
All LIKE patterns	🔵 O(n) — linear
GROUP BY family	🔵 O(n) — linear
Window functions (LAG/LEAD/ROW_NUMBER)	🔵 O(n) — linear
COUNT(DISTINCT)	🔵 O(n) — linear

Every measured operation scales at O(n) or better — no quadratic blow-ups in the hot path.

📊 Full matrix (all row sizes)

Basic operations

Operation	1k	5k	10k	20k	50k
Simple SELECT *	1.88 ms	1.54 ms	1.57 ms	1.57 ms	1.64 ms
WHERE numeric	5.66 ms	17.95 ms	33.34 ms	65.56 ms	160.6 ms
WHERE string eq	7.20 ms	27.83 ms	54.73 ms	106.7 ms	262.4 ms
Complex WHERE	14.57 ms	60.74 ms	123.7 ms	234.7 ms	588.6 ms
ORDER BY single	1.90 ms	1.82 ms	2.12 ms	2.79 ms	5.55 ms
ORDER BY multi	2.06 ms	2.32 ms	3.39 ms	5.51 ms	14.28 ms
COUNT(DISTINCT)	5.75 ms	22.40 ms	38.63 ms	78.69 ms	186.0 ms

LIKE pattern matching

Operation	1k	5k	10k	20k	50k
Suffix wildcard	5.75 ms	19.69 ms	37.42 ms	70.27 ms	170.0 ms
Prefix wildcard	6.35 ms	19.00 ms	35.60 ms	69.96 ms	168.1 ms
Both wildcards	5.82 ms	19.29 ms	36.90 ms	70.80 ms	219.7 ms
Multiple LIKEs	9.64 ms	36.25 ms	70.98 ms	141.8 ms	331.6 ms
With result set	5.54 ms	18.62 ms	35.39 ms	68.94 ms	172.8 ms

GROUP BY

Operation	1k	5k	10k	20k	50k
Simple	16.50 ms	58.39 ms	111.0 ms	147.1 ms	261.0 ms
With SUM	20.78 ms	78.40 ms	148.6 ms	221.8 ms	441.8 ms
Multiple aggs	45.96 ms	145.5 ms	276.0 ms	447.5 ms	1.03 s
Multi-column	46.74 ms	205.6 ms	405.4 ms	647.7 ms	1.39 s

Window functions

Operation	1k	5k	10k	20k	50k
LAG	10.11 ms	42.21 ms	78.09 ms	154.4 ms	394.3 ms
LEAD	10.08 ms	39.12 ms	78.94 ms	169.3 ms	390.2 ms
LAG + LEAD	10.48 ms	41.67 ms	82.75 ms	170.3 ms	427.5 ms
LAG w/ PARTITION	13.01 ms	52.79 ms	106.2 ms	200.4 ms	505.4 ms
ROW_NUMBER	9.68 ms	38.67 ms	82.96 ms	156.6 ms	382.7 ms

JOINs

Operation	1k	5k	10k	20k	50k
Hash JOIN — small	2.79 ms	2.76 ms	3.42 ms	3.25 ms	3.33 ms
Hash JOIN — medium	3.08 ms	4.33 ms	7.33 ms	6.26 ms	6.26 ms
Nested loop	3.70 ms	20.20 ms	78.30 ms	71.93 ms	71.30 ms
Self-join cumsum	4.84 ms	40.98 ms	44.36 ms	43.91 ms	42.08 ms
LEFT JOIN ineq.	3.72 ms	20.71 ms	75.87 ms	74.60 ms	72.22 ms
JOIN w/ CTE cats	3.89 ms	7.42 ms	12.59 ms	14.48 ms	13.42 ms

Reproduce locally: uv run scripts/benchmark_all.py --save — first run seeds a baseline, subsequent runs can compare with --compare benchmark_baseline.json.

📋 View all commits

• ci: Publish to crates.io in the manual release workflow (TimelordUK)
• docs(tui): Document undocumented-but-working key bindings (TimelordUK)
• ci: Guard uv venv against existing cached .venv (TimelordUK)
• docs(tui): Remove F7/F12 from help — bindings don't fire at runtime (TimelordUK)
• docs(tui): Fix stale entries in native TUI help page (TimelordUK)
• feat: Add FILE CTE parser scaffold (parser-only, execution stubbed) (TimelordUK)
• fix: Set from_source in ExpressionLifter to fix QUALIFY regression (TimelordUK)
• refactor: Improve CTE handling in source table extraction (TimelordUK)
• docs: Add comprehensive PIVOT examples with best practices (TimelordUK)
• feat: Migrate query execution to use unified from_source field - PIVOT now works end-to-end! (TimelordUK)
• refactor: Add unified from_source field to SelectStatement and integrate PIVOT expansion (TimelordUK)
• feat(pivot): Add PivotExpander transformer (Phase 4 - partial) (TimelordUK)
• feat(pivot): Add PIVOT parser implementation (TimelordUK)
• feat(pivot): Add PIVOT AST structures and pattern matching (TimelordUK)
• feat(pivot): Add PIVOT/UNPIVOT lexer tokens and test data (TimelordUK)
• feat: Implement SQL standard implicit window frames (TimelordUK)
• chore: Bump version to v1.67.0 (TimelordUK)
• feat: Make batch window evaluation the default and fix expression handling (TimelordUK)
• fix: Update Python tests to use assertions instead of return values (TimelordUK)
• feat: Optimize window aggregates for UNBOUNDED PRECEDING frames (TimelordUK)
• feat: Implement batch evaluation for window functions - 86% performance improvement! (TimelordUK)
• feat: Window function optimization Phase 2 + Step 0 prep for batch evaluation (TimelordUK)
• feat: Add Phase 1 window function profiling infrastructure (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.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