0.9.2

• support subqueries as columns
• add PI, FLOOR, CEIL and ROUND functions
• improved HTML output formatting
• fixed bugs

Thanks to @mathrick for another reported issues!

0.9.1

• complex subqueries which can refer their parent tables #124
• EXISTS / NOT EXISTS operator
• CURRENT_TIMESTAMP, CURRENT_TIME functions
• filename column (just the name of a file without extension)
• improved error reporting #182

Thanks to @mathrick and @shah for creating the issues which helped to make this release!

0.9.0

• subqueries support
• bash completion #174
• make checking for hardlinks an optional setting for every search root
• new fields exif_exposure_time (or exif_exptime), exif_aperture, exif_shutter_speed, exif_f_number (or exif_f_num), exif_iso_speed (or exif_iso), exif_focal_length (or exif_focal_len), exif_lens_make, exif_lens_make #177
• path returns a relative path #178

Thanks to @Xanadul, @gwiener, @volodyalipkin and @mathrick for their suggestions and bug-reports that helped to form this release!

0.8.12

• search logic optimized to check files against more lightweight conditions first
• supported IN (...list of values...) expression
• LEAST and GREATEST functions
• LOCATE function
• added .awk as a known source code file extension

Thanks to @ototo for testing and reporting failed builds #173 (due to a broken semver in one of the dependencies)!

0.8.11

• bugfixes, including #171 and #172
• added running time measurements for debug mode

Thanks again @volodyalipkin for reporting the issues!

0.8.10

• query created and modified as relative date #169
• .gitignore support is now an optional feature (to let build fselect without libgit2)
• fix GROUP BY with ORDER BY #170

Thanks to @diegotolentino and @volodyalipkin for reporting bugs and sharing ideas!

0.8.9

• added ABS, EXP, LN and LOG functions
• better support search roots with spaces
• fixed various bugs including #150 and #167

Thanks to all contributors and bug reporters! @4censord @paolobarbolini @rickhg12hs 🌃

0.8.8

• improved .gitignore handling
• fixed parsing search roots with spaces #150
• various bugfixes, including #152 and #163

Many thanks to everyone, who sent their PRs, opened issues and gave valuable feedback!
@dangnhdev @Dominiquini @durka @jeff-arnold @JonathanDoughty @Matthieu-LAURENT39 @rickhg12hs

0.8.6

• 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

0.8.5

• 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!