Cannot use string filters on foreign keys

[nitlev]

I have checked discourse and github, sorry if it's still a duplicate

When trying to filter on a text column that happens to be declared as a foreign key to another column, the UI only offers me the Is and Is not options.

Notably, it lacks the contains, starts with, is empty, ... filtering options that are generally available for text columns:

I've also tried to modify the Filtering on this field config of the table, but nothing fixes it.

Note:

1. This is on Metabase v0.49.1, using a BigQuery connection.
2. I tried and could not reproduce the issue on the Sample Database