Describe the new feature

It would be nice to have some options besides 'like' when filtering in the browser.

Similar to Excel's "blanks", "non-blanks" in Autofiltered columns. (I'm not a big fan of "top 10")

I'd add "NULL" & "not NULL" as you can't type anything to represent them, and perhaps "Blob" and "not Blob" for the same reason. These are helpful when looking for anomalies.

It's possible to get at NULL values for a single column by sorting & scanning visually, but that doesn't scale.

It's possible to drop into SQL to do this, but that result table can't be filtered (except by writing more SQL). Hmmm - would it be possible to have the browser take the results of my query and load them into the filterable window? e.g. create a temporary table from the results of a select in the "execute SQL' tab, and put that into your nice filterable table. Seems like that would be straightforward for viewing (my primary use case), but harder to send modifications back to the real tables.

It also would be useful to add a simple JOIN column (e.g. viewing orders, would be nice to add 'join order.customerid = customers.id')

Additional info

Please answer these questions before submitting your feature request.

Is your feature request related to an issue? Please include the issue number.

No

Does this feature exist in another product or project? Please provide a link.

Excel.

Do you have a screenshot? Please add screenshots to help explain your idea.

Nope. Just run excel autofilter on any spreadsheet and look at the dropdowns. [All] [Blanks] [Non-Blanks] [Custom]