fselect replaces the complexity of traditional file search tools with an intuitive SQL-like query language. Instead of memorizing dozens of flags and options, you write queries that read like English: select name where size > 1g or select path from ~/photos where width > 2000.

The tool handles everything from basic file searches to advanced operations. Search across multiple directories, look inside ZIP archives, extract EXIF data from photos, read MP3 metadata, and check file permissions and ownership — all with straightforward queries. You can use aggregate functions like COUNT, SUM, AVG, MIN, and MAX to get statistics about your files without piping through multiple commands.

Key capabilities include:

SQL-like syntax that's intuitive and memorable
Aggregate functions for file statistics and analysis
Archive searching to look inside ZIP files
Media metadata extraction from MP3s and images
EXIF support with 40+ image fields
Permission checking including SUID bits and ACLs
Subqueries for complex file comparisons
Multiple output formats (JSON, CSV, HTML, tabs)
Gitignore support to skip ignored files
Interactive REPL mode for exploratory searching

Installation is straightforward across platforms — Cargo, Homebrew, AUR, Debian, Windows package managers, and static binaries are all available. The tool respects your system's conventions while providing a modern, developer-friendly interface for file discovery and analysis.