I would like a dating site filter that excludes people whose ‘looking for partners age X ~ Y’ range does not include their own age
(I think it is okay to have arbitrary preferences and make no conscious judgment on the people this filter would exclude, other than ‘I judge that I am less likely to enjoy dating these people’)
I would like basically all sites that list something to let me filter on any and all criteria I can imagine. Just let me point an SQL Server Browser directly at the database. Please. Your UX designers have no idea what I want and only let me filter on irrelevant nonsense.
Counterpoint: letting users feed arbitrary SQL to your database is generally considered a security risk. You’d need a full SQL parser of your own to even have a chance of properly restricting them.
Just give me SELECT WHERE