Ok, so imagine this. Imagine that I am searching through a database, and one of the columns is "FRUIT". In the "FRUIT" column, there are several possible values that are different types of apples. For instance, "Honeycrisp Apple", "Gala Apple", "Granny Smith Apple", and so on. Sometimes, I might want to combine these results into simply "Apple", and an easy way to do that would be to just write a bunch of case statements.
WHEN "Gala Apple" THEN "Apple"
WHEN "Honeycrisp Apple" THEN "Apple"
Then I can just group on "Apple". Now, I know I can just write this in SQL but then I don't have the built in filterability. Is there a way to replicate this in Metabase using the editor so that I retain the ability to filter?