The main difference is that with CSS you can have unintended interactions.

With SQL you get unintended query plans, but it always returns the same rows (if it doesn't time out).