There is also Hayt for CQL (cassandra). It's quite mature and used by yapster, featured recently on juxt blog among others.

Queries are plain clj maps and there is also a thin dsl provided.

https://github.com/mpenet/hayt

In our case we use it to generate prepared statements but we avoid using this kind of query gen on live/hot paths.