What is a common mistake with Where filtering in LINQ?

Using non-translatable custom methods in an EF Core predicate can break SQL translation. In practice, the value of this concept comes from understanding where it belongs in the architecture, what problem it solves, and what constraints or tradeoffs it introduces.