fselect

• support duration extraction from WAV files
• add IS_FONT field for ad hoc font file extensions detection
• support .gradle as known source code file extension
• add .DJV as another ad hoc known file type

• added BETWEEN operator #139
• added FORMAT_TIME function #143
• check for updates (optional feature disabled by default) #138
• added mkv duration extractor #140
• added quit and exit commands for interactive mode
• added .tsx as a known source file extension

Many thanks go to @4censord, @Dialga and @Luxzi who contributed to this release!

• parse search options with no search root specified (i.e., for the current directory) #133
• winget package added #134
• bugfixes #132

Many thanks to @chenrui333, @lcook, @mahdi739 and @thechampagne who contributed to this release!

• GROUP BY
• don't require braces for functions without arguments
• added capabilities field
• added HAS_CAPABILITY function
• added CUR_DATE synonym
• get dimensions from .webm and .tga files
• panics replaced with a graceful exit with an error message

Thanks to @steffenbusch and @tan-wei for raising issues that really helped to improve the project!

• added HAS_CAPABILITIES (aka HAS_CAPS) function to spot files with assigned capabilities on Linux
• added INITCAP function
• added .exr to the known image file extensions list
• added .sol as recognized file extension of the source files

• SQRT function
• add .zig as recognized file extension of the source files
• add return values depending on query parsing result and any errors during reading directories

Thanks to @umaxfun for the PR!

• Feature request: allow braces { } in place of ( ) #111
• add FROM_BASE64 function, add an alias TO_BASE64 for BASE64 function
• Fixed #119 #120 #121 , improved #75

Thank you @jgranduel, @notfed, and @rickhg12hs for the issues posted that helped to make this shiny new release!

• allow "from" at end of query #110
• add .ts and .jsx as recognized file extensions of the source files

Thanks to @notfed for the suggestion with an alternate from syntax!

• Generic "NOT"/Negation #114
• added mod operator
• "where" clause with just a column name for boolean columns #75
• scoop package #118
• deb package #113
• bugfixes and improvements

Thanks to @danieldjewell, @ethanhs, @kintrupf, @QaidVoid, @rasa, @rickhg12hs, and @zhangxp1998 for their impressive PRs, package management, and bug reports!

• added POW function
• supported JPEG XL and SVG images to read dimensions from
• added .odp to known document type file extension list
• fixed file access mode formatting

Thanks to @pavlus for the great PRs, as well as to @CompuRoot, @Dialga, and @rickhg12hs for creating the issues that has been addressed in this release!

• added BIN function
• added EEQ and ENE aliases for === and !== operators
• improved EXIF GPS fields handling
• fixed bugs

Thank you, @balta2ar, @ericphelps and @rgelb, for creating the issues that helped to improve fselect a little bit more!

• added dir, absdir, and ext fields
• added is_empty field to search for the empty directories and files
• added .jl to known file extensions list
• added Macports install info
• fixed bugs, interactive mode is back

Thanks to @Allaman, @dclong, @engineerchange, @herbygillot, and @rickhg12hs for submitting issues and PRs!

• added CURRENT_USER/CURRENT_UID/CURRENT_GROUP/CURRENT_GID functions
• greatly improved FORMAT_SIZE function, added config option for default file size format
• added synonyms for LOWER and UPPER functions (LOWERCASE and UPPERCASE respectively)
• improved interactive mode
• fixed bugs

Thanks to @Roguelazer, @RustemB, and @YodaEmbedding for their suggestions, issues, and pull requests!

• option to specify config location
• check for config in the same directory with the executable
• added CURRENT_DATE and RAND functions
• fixed bugs

Many thanks to @Dialga, @gd4c, @johnstonskj, and @rickhg12hs for their ideas, discussions, bugreports, and pull requests!

• statistics functions (STDDEV_POP, STDDEV_SAMP, VAR_POP, and VAR_SAMP)
• rx parameter for search roots to search within multiple directories matched by regular expression
• updated runtime documentation

Thanks to @rickhg12hs for bugreports and ideas!

• interactive mode
• protection against cycles with symlinks or hardlinks #4
• LTRIM, RTRIM, TRIM, and DAYOFWEEK functions
• added workaround to work on RAMdisks #68
• fixed bugs

Thanks to @glmdev, @kintrupf, and @ngirard for reporting issues and ideas!

• NOT keyword (e.g., where name not like '%.tmp')
• added .d to the list of source file extensions
• alternate form !~= of notrx operator
• TRIM, REPLACE, UCASE and LCASE (synonyms for UPPER and LOWER) functions
• .dockerignore support
• dockerignore, gitignore, and hgignore boolean config parameters with default options for search within any roots, if not specified otherwise

Thanks to @chenrui333 for CI/CD fix.

• added SUBSTRING or SUBSTR function
• added LEN as a synonym for LENGTH function
• extract EXIF data from HEIF files
• added device, inode, blocks, and hardlinks fields (Linux only)
• bugfixes

Thanks to @jmbowman for suggestion about reading EXIF in HEIF files, and to @kamadak for the implementation.

• added CONCAT, CONCAT_WS, COALESCE functions
• added FORMAT_SIZE function, file size unit specifiers split into binary and decimal
• added .heic extension to the image formats list
• improved detection of Japanese characters in file names

• added functions for Japanese symbols detection in filenames and other strings
• added Cargo.lock for easier package maintenance #61

Many thanks to @samford and @filalex77 for their efforts!