Which kind of sucks. If you want to filter a column, it has to either be an aggregate function of all rows, or it has to be stored in that table or in a path from that table. It can’t be a function of that row. Which kind of sucks, it means that any row level functional properties have to be maintained when you do a row save.
And thus were spent 4 hours of my Sunday.