I think SELECTs without WHERE clauses are fine
But requiring them is fine too. Even more on Postrges, that has booleans.