I am adding CASE statements to my filter in my views. I basically want
that if the user types `Harry` the filtering should happen on
`Gryffindor`. This is my code:filter: house { # type: string # sql:
${TABLE}.house ;; sql: CASE WHEN ${TABLE}.house L...