fselect

fselect is a command‑line utility that lets users locate files using a SQL‑like query language. It accepts column selections, source directories, and optional clauses such as WHERE, GROUP BY, ORDER BY, LIMIT, and OFFSET, producing results in formats like CSV or JSON. The syntax is deliberately relaxed, allowing complex expressions, subqueries, and aggregate functions without requiring full SQL compliance.

The tool targets developers, system administrators, and power users who need more expressive file‑search capabilities than traditional `find` or `ls`. It supports searching inside archives, respecting ignore files (e.g., .gitignore), and filtering by image dimensions, EXIF data, MP3 tags, extended attributes, POSIX ACLs, Linux capabilities, file hashes, and MIME types. An interactive mode provides a REPL‑style interface for exploratory queries.

fselect is distributed as a Rust binary and available through multiple package managers on Linux, Windows, and macOS. It is stable, core‑cli‑available, and can be built from source with Cargo or installed via precompiled packages.