The rule RSPEC-1590 considers only an WHERE clause, but instead of the WHERE clause, an JOIN could be also valid. For example:
DELETE FROM dbo.Products;
DELETE FROM dbo.Products WHERE ProductId = 1;
DELETE p FROM Products as p INNER JOIN DeletedProducts as dp ON p.ProductId = dp.ProductId
For UPDATE queries it’s similar.