Limit, OFFSET and BETWEEN don't work in Cassandra

Well to be honest you just don't use Cassandra with the thinking that you will perform regular SQL queries. It's an illusion. It's real use cases are more specialized.