Commercial SQL databases have been doing predicate push-down (even on joins) since the 1990s at least. It’s a table-stakes feature.