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

v1.55.0

SQL CLI v1.55.0

Release Date: September 27, 2025

📊 Release Overview

• Commits in this release: 41
• Files updated: 86

✨ Highlights

🎨 Visual Improvements

🔍 Enhanced Debugging

• Better Diagnostics: Improved error messages and state dumps

📝 Changes by Category

🚀 New Features

• Add enhanced query history UI with split-pane preview
• Update Flask test server to accept SQL-CLI Web CTE format
• Add query history system with telescope-style recall
• Release v1.55.0 - Windows Nvim export support & performance docs
• Improve export notifications and clean output
• Add 100K rows to benchmark suite
• Add JSON selector proxy server with FORM_FILE upload and JSON prettification
• Add comprehensive bitwise operations and binary visualization functions
• Complete rewrite of Neovim template system with major improvements

🐛 Bug Fixes

• Correct macro format in web_query template
• Use macro for API URL to avoid colon parsing issue
• Update web_query template for Flask test server compatibility
• Export clean TSV/CSV data directly from sql-cli
• Use Parser:: instead of Self:: in free functions
• Resolve circular reference and nil handling in template system

🔧 Refactoring

• Remove dead get_binary_op and get_arithmetic_op methods
• Extract is_valid_identifier helper to eliminate identifier validation duplication
• Remove dead parse_select_list method
• Extract update_paren_depth helper to eliminate parenthesis tracking duplication
• Remove more dead code from incomplete tokenization work
• Remove unused is_reserved_keyword method and clarify string-based checking
• Extract parse_argument_list helper to eliminate argument parsing duplication
• Extract find_quote_start helper to eliminate quote parsing duplication
• Extract handle_method_call_context helper to eliminate more duplication
• Extract check_after_comparison_operator helper to eliminate large duplication
• Extract check_balanced_parentheses helper to eliminate final duplication
• Extract parse_optional_alias helper to eliminate more code duplication
• Extract common CTE parsing logic to eliminate code duplication
• Extract WEB CTE parsing into dedicated module
• Remove string literals from recursive parser
• Optimize parser keyword handling - reduce string allocations

📚 Documentation

• Add comprehensive performance documentation
• Design structured data selector for hierarchical object querying
• Add FIX engine integration design document
• Document ROW_NUMBER() window function bug with CTEs

📋 View all commits

• demo server to publish trades from a template cte in nvim (TimelordUK)
• feat: Add enhanced query history UI with split-pane preview (TimelordUK)
• fix: Correct macro format in web_query template (TimelordUK)
• fix: Use macro for API URL to avoid colon parsing issue (TimelordUK)
• fix: Update web_query template for Flask test server compatibility (TimelordUK)
• feat: Update Flask test server to accept SQL-CLI Web CTE format (TimelordUK)
• feat: Add query history system with telescope-style recall (TimelordUK)
• feat: Release v1.55.0 - Windows Nvim export support & performance docs (TimelordUK)
• windows export browser (TimelordUK)
• windows clip board (TimelordUK)
• open browser from windows in nvim (TimelordUK)
• feat(nvim): Improve export notifications and clean output (TimelordUK)
• fix(nvim): Export clean TSV/CSV data directly from sql-cli (TimelordUK)
• docs: Add comprehensive performance documentation (TimelordUK)
• feat: Add 100K rows to benchmark suite (TimelordUK)
• refactor: Remove dead get_binary_op and get_arithmetic_op methods (TimelordUK)
• fix: Use Parser:: instead of Self:: in free functions (TimelordUK)
• refactor: Extract is_valid_identifier helper to eliminate identifier validation duplication (TimelordUK)
• refactor: Remove dead parse_select_list method (TimelordUK)
• refactor: Extract update_paren_depth helper to eliminate parenthesis tracking duplication (TimelordUK)
• refactor: Remove more dead code from incomplete tokenization work (TimelordUK)
• refactor: Remove unused is_reserved_keyword method and clarify string-based checking (TimelordUK)
• refactor: Extract parse_argument_list helper to eliminate argument parsing duplication (TimelordUK)
• refactor: Extract find_quote_start helper to eliminate quote parsing duplication (TimelordUK)
• refactor: Extract handle_method_call_context helper to eliminate more duplication (TimelordUK)
• refactor: Extract check_after_comparison_operator helper to eliminate large duplication (TimelordUK)
• refactor: Extract check_balanced_parentheses helper to eliminate final duplication (TimelordUK)
• refactor: Extract parse_optional_alias helper to eliminate more code duplication (TimelordUK)
• refactor: Extract common CTE parsing logic to eliminate code duplication (TimelordUK)
• refactor: Extract WEB CTE parsing into dedicated module (TimelordUK)
• chore: Update .gitignore for .NET build artifacts (TimelordUK)
• feat: Add JSON selector proxy server with FORM_FILE upload and JSON prettification (TimelordUK)
• docs: Design structured data selector for hierarchical object querying (TimelordUK)
• docs: Add FIX engine integration design document (TimelordUK)
• feat: Add comprehensive bitwise operations and binary visualization functions (TimelordUK)
• docs: Document ROW_NUMBER() window function bug with CTEs (TimelordUK)
• refactor: Remove string literals from recursive parser (TimelordUK)
• Add test_trades_multi.csv data file (TimelordUK)
• fix: Resolve circular reference and nil handling in template system (TimelordUK)
• refactor: Optimize parser keyword handling - reduce string allocations (TimelordUK)
• feat: Complete rewrite of Neovim template system with major improvements (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.54.0

SQL CLI v1.54.0

Release Date: September 24, 2025

📊 Release Overview

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

✨ Highlights

🔍 Enhanced Debugging

• Better Diagnostics: Improved error messages and state dumps

📝 Changes by Category

🚀 New Features

• Support multiple JOIN conditions connected by AND
• Add table alias support for self-joins in SQL queries
• Improve token manager with better debugging and PowerShell support
• Add script-based token fetching with auto-refresh timer
• Add @{MACRO:name} syntax for recursive macro expansion
• Add explicit macro expansion syntax for better control

📋 View all commits

• perf: Massive GROUP BY performance improvement (6x faster!) (TimelordUK)
• feat: Support multiple JOIN conditions connected by AND (TimelordUK)
• perf: Dramatically reduce test build time by consolidating test executables (TimelordUK)
• feat: Add table alias support for self-joins in SQL queries (TimelordUK)
• feat: Improve token manager with better debugging and PowerShell support (TimelordUK)
• feat: Add script-based token fetching with auto-refresh timer (TimelordUK)
• feat: Add @{MACRO:name} syntax for recursive macro expansion (TimelordUK)
• feat: Add explicit macro expansion syntax for better control (TimelordUK)
• fix for json escaped double quotes (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.53.0

SQL CLI v1.53.0

Release Date: September 23, 2025

📊 Release Overview

• Commits in this release: 33
• Files updated: 45

✨ Highlights

🔍 Enhanced Debugging

• Better Diagnostics: Improved error messages and state dumps

📝 Changes by Category

🚀 New Features

• Add utility functions for character codes, type conversions, and encoding
• Add JWT token refresh system for nvim plugin
• Add generic macro template system with function patterns for nvim plugin
• Add recursive macro expansion support
• File-based configuration for template system
• Enhanced template system with inline SQL macros
• Add SQL template/macro system for Neovim plugin
• Enhance WEB CTE with HTTP methods, JSON path extraction, and request body support
• Add VALUES and ARRAY generators for literal value tables
• Add big_math.sql example and parser refactoring TODO

🐛 Bug Fixes

• Handle window keywords in ORDER BY clause
• Handle window keywords as column names in expression context
• Complete WEB CTE formatter support and nvim macro improvements
• Skip formatting for WEB CTE queries in nvim plugin
• Resolve environment variables in nvim macro CONFIG section
• Preserve buffer content when expanding macros
• Update TODAYS_TRADES macro to include SOURCE variable
• Handle multi-line macro expansions correctly
• Allow underscores in macro names for @macro pattern
• Keep table headers visible when navigating large result sets in Neovim
• Use localhost URLs in WEB CTE tests to avoid CI timeouts

🔧 Refactoring

• Replace string literals with token-based parsing in cursor context analysis
• Reorganize Neovim keybindings for better organization
• Replace hardcoded SQL keywords with proper Token matching in parser
• Major parser improvements - remove hardcoded logic, add tracing

📚 Documentation

• Add token management documentation

📋 View all commits

• fix format (TimelordUK)
• failing test sql (TimelordUK)
• fix: Handle window keywords in ORDER BY clause (TimelordUK)
• fix: Handle window keywords as column names in expression context (TimelordUK)
• feat: Add utility functions for character codes, type conversions, and encoding (TimelordUK)
• docs: Add token management documentation (TimelordUK)
• feat: Add JWT token refresh system for nvim plugin (TimelordUK)
• feat: Add generic macro template system with function patterns for nvim plugin (TimelordUK)
• refactor: Replace string literals with token-based parsing in cursor context analysis (TimelordUK)
• fix: Complete WEB CTE formatter support and nvim macro improvements (TimelordUK)
• Revert "fix: Skip formatting for WEB CTE queries in nvim plugin" (TimelordUK)
• fix: Skip formatting for WEB CTE queries in nvim plugin (TimelordUK)
• fix: Resolve environment variables in nvim macro CONFIG section (TimelordUK)
• fix: Preserve buffer content when expanding macros (TimelordUK)
• fix: Update TODAYS_TRADES macro to include SOURCE variable (TimelordUK)
• feat: Add recursive macro expansion support (TimelordUK)
• fix: Handle multi-line macro expansions correctly (TimelordUK)
• feat: File-based configuration for template system (TimelordUK)
• fix: Allow underscores in macro names for @macro pattern (TimelordUK)
• feat: Enhanced template system with inline SQL macros (TimelordUK)
• feat: Add SQL template/macro system for Neovim plugin (TimelordUK)
• refactor: Reorganize Neovim keybindings for better organization (TimelordUK)
• fix: Keep table headers visible when navigating large result sets in Neovim (TimelordUK)
• fix: Use localhost URLs in WEB CTE tests to avoid CI timeouts (TimelordUK)
• refactor: Replace hardcoded SQL keywords with proper Token matching in parser (TimelordUK)
• feat: Enhance WEB CTE with HTTP methods, JSON path extraction, and request body support (TimelordUK)
• update documents around progress in parser and tokenisation (TimelordUK)
• add a generator example for a literal array of numbers (TimelordUK)
• feat: Add VALUES and ARRAY generators for literal value tables (TimelordUK)
• refactor: Major parser improvements - remove hardcoded logic, add tracing (TimelordUK)
• improve big math (TimelordUK)
• add big_math example (TimelordUK)
• feat: Add big_math.sql example and parser refactoring TODO (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.52.1

SQL CLI v1.52.1

Release Date: September 21, 2025

📊 Release Overview

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

✨ Highlights

📝 Changes by Category

🐛 Bug Fixes

• Properly handle parenthesis depth tracking in CTE parsing

📋 View all commits

• patch for parser fix (TimelordUK)
• fix: Properly handle parenthesis depth tracking in CTE parsing (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