General info about SQL and Predicates Search terms: SQL Predicate

Using predicate expressions Search terms: Predicate Expression

Compare field and value Search terms: CompareValue*

Null values in filters Search terms: Null Predicate

SubqueriesSearch terms: Subquery OR FieldCompareSet*

Custom filters in ON clauses in JOINs Search terms: CustomFilter