I gotta wonder how Clustrix compares to this. Also is this similar to using a SQL layer with Cassandra.
Cassandra's query language, CQL, is not really comparable since it only supports such a small subset of SQL. Also, Cassandra uses eventual consistency in place of doing distributed transactions.