jhspetersson/fselect 0.10.4 on GitHub

IS NULL and IS NOT NULL operators.
depth field.
CONTAINS_CYRILLIC function; better Japanese text detection.
STRPOS function, split from LOCATE.
rlike as a regex operator alias.
Encrypted entries in zip archives; more fields available for archived files, with archive paths included in their values.
include: directives in .hgignore and .dockerignore.
Function argument counts and literals compared with typed expressions are checked when the query is parsed.
Integration test suite covering traversal, ignore files, formats, grouping, dates, archives and CLI flags.

Expressions carry static types; caches, sorting, grouping and aggregates work on typed values instead of rendered text.
fsize is numeric: it compares, groups, sorts and aggregates by byte count while printing the formatted size.
CURRENT_DATE, NOW, DATE_ADD, DATE_SUB, FROM_UNIXTIME, LAST_DAY and DATE_TRUNC return datetimes.
LEAST and GREATEST operate on strings as well as numbers.
xattr() returns values that are not UTF-8 as 0x.. hex instead of an empty string (#187).
Unknown columns in GROUP BY and ORDER BY, ungrouped columns in grouped queries, an empty IN () and an incomplete WHERE clause are rejected.
A literal that can never match a typed expression (length(name) > 'abc') is rejected before the search starts.
LIKE '' matches the empty string.
Bare words are treated as function calls only for functions that take no arguments.
Root aliases are case-insensitive; JSON column names are lowercase.
Search roots defined by subqueries inherit the root options of the parent query; a grouped subquery in FROM yields one entry per group.
Faster sorting, aggregates, subquery caching, BFS traversal with LIMIT, deferred evaluation of heavy columns.

GROUP BY merged distinct values that render alike, such as sizes of 10,241 and 10,242 bytes both shown as 10.00KiB.
Missing boolean values sorted as false instead of last.
HAVING, aggregate aliases and MIN/MAX/COALESCE corner cases.
Correlated subqueries: caching, nested contexts and the group values they see.
Symlink handling and ignore rules applied across symlinks.
SVG dimension detection, MP4 duration and exif_alt for negative altitudes.
Errors no longer break JSON and HTML output or the row count.
--help and --version after other arguments; paths containing whitespace; floating point literals and unary minus.
Windows: datetime formatting, Unix permission fields, extended attributes on musl builds.
Subquery OFFSET applied twice; depth calculation; path under symlinks.