The limits of the WHERE keyword

At this point, we've seen that you can look up rows by partition key alone, or by a combination of a partition key and a clustering column. We can easily imagine other ways to use WHERE, but it's not as flexible as we might hope.