[qoi2ijds0]

Only for every returned row. The projection does not affect the underlying result set, it merely "shapes" the results you have received. WHERE clauses are always run before SELECT

[VintageCool]

The query in the article has no WHERE clause. It must calculate that function for every row in `commits`.