Maybe you should take a look at fselect, that uses SQL dialect for search queries and supports archives (and much more).

https://github.com/jhspetersson/fselect

tbh, I probably wouldn't have written zfind if I had known about this.

fselect still takes the SQL analogy a bit too far for my taste, still cool though :)

Oh and fselect doesn't do tar.

Also tbh, I strongly prefer your query strategy; it doesn’t require I remember an entire grammar, just a few keywords (‘size’ etc) which are probably at the top of your man page. If a replacement for ‘find’ - which annoys me because I have to dig through the man page anytime I do something nontrivial- forces me to dig through their man page to remember a grammar … you catch my drift. Hope you keep keepin on, and thanks.

This looks awesome, I'm gonna play with this today. Thanks for the rec