Someone asked so I wrote the difference here https://github.com/deanhiller/playorm/wiki/Fast-Scalable-Queries
playOrm queries are geared for a different problem then CQL is geared for. Summary is basically playOrm uses significantly less resources as it only queries the partitions it is interested in. This is also why playOrm can do joins very quickly as well. Dean
