Yes! I kind of envision it like Excel or Google Sheets does Filtering, for a table view:
Each table column allows you to set a filter, selecting ALL, selecting BLANKS, or selecting particular values. Additionally, as Excel does, you can filter based on "Text Filters..." which includes Equals, Does Not Equal, Begins with, Ends with, Text Contains, Text Does Not Contain, and Custom Auto Filter...which gives all sorts of flexibility.
If each column of your table allowed for this kind of filtering, you'd have unlimited ability to drill-down or expand to find your precise criteria.
My clients want the ability to view products that contain a certain ingredient "sodium" somewhere in the ingredient name that is an ACTIVE ingredient for that product, AND also contains a different ingredient, like "iodine" that is INACTIVE for that product, while also filtering off of the product's Manufacturer or whether the product status is allowed or prohibited. It's a lot of if/then scenarios all nested.
Having a search function do this as well would be awesome. The biggest issue I have now is that filtering on "contains" doesn't really contain - you are still forced to choose from specific items. We have tons of ingredients that contain sodium, and I don't want to select each one - I just want the filter to find all ingredients with "sodium" somewhere in the word.
Thanks for considering this!