duriantaco/jonq v0.2.0

on GitHub

[v0.2.0] - 2026-03-08

Added

• DISTINCT: select distinct city returns unique rows
• COUNT DISTINCT: select count(distinct city) as n
• Standalone LIMIT: select * limit 10 (independent of sort)
• IN operator: select * if city in ('New York', 'Chicago')
• NOT operator: select * if not age > 30
• LIKE operator: select * if name like 'Al%' (supports % wildcard for startswith, endswith, contains)
• String functions: upper(), lower(), length()
• Math functions: round(), abs(), ceil(), floor()
• Schema preview: run jonq data.json with no query to inspect fields and types
• Interactive REPL: jonq -i data.json for interactive querying
• Watch mode: --watch flag to re-run query on file change
• URL fetch: jonq https://api.example.com/data "select id"
• Multi-file glob: jonq 'logs/*.json' "select *"
• Auto-detect NDJSON: no flag needed for newline-delimited JSON
• Fuzzy field suggestions: typo correction with Levenshtein distance
• Colorized output: syntax-highlighted JSON when outputting to terminal
• python -m jonq: added __main__.py entry point
• Constants module: centralized all magic numbers and ANSI codes

Fixed

• Dynamic HAVING field mappings instead of hardcoded alias dict
• Removed inline jq comments (# sum) from generated filters
• from clause now correctly iterates arrays (.path[] instead of .path)
• Schema validator recognizes sort, distinct, as, arithmetic operators
• Schema validator skips validation when from clause is used
• Logging level changed from INFO to WARNING (no more filter spam)

Changed

• Version bump to 0.2.0
• Replaced all star imports with explicit imports
• Replaced all hardcoded ANSI codes with _Colors class
• Replaced all magic numbers with named constants
• Removed dead code: handle_error, extract_value_from_quotes, _AGG_FUNCTIONS, parse_condition (jq_filter.py), use_fast parameter
• Executor raises ValueError instead of RuntimeError for jq errors
• Updated all Sphinx docs, README, and SYNTAX.md