Advanced & More powerful search

[Azathothas]

from a conversation on discord: https://discord.com/channels/1313385177703256064/1313387041186381824/1328187926848344116

soar search --help
--case-sensitive     Case sensitive search
--disabled-only      Show Only Disabled Packages #By default soar hides packages that have been disabled
--filter             Hide results matching this string
--include-disabled   Shows Regular + Disabled Packages
--portable-only      Only Show Portable Packages #(shows all packages from `.bincache` & for `pkgcache`, it shows only that have `[PORTABLE]` in one of their note)
--query              "${ADVANCED_QUERY}" #using sqlite style...? or some other dsl...?

@QaidVoid suggested we use https://github.com/apache/datafusion-sqlparser-rs
But other ideas (& better PRs) are welcome