A new Apache Calcite adapter allows you to access Apache Cassandra via industry-standard SQL.
You can map a Cassandra keyspace into Calcite as a schema, Cassandra CQL tables as tables, and execute SQL queries on them, which Calcite converts into CQL. Cassandra can define and maintain materialized views but the adapter goes further: it can transparently rewrite a query to use a materialized view even if the view is not mentioned in the query.
Read more about the adapter here.
The Cassandra adapter is available as part of Apache Calcite version 1.7.0, which has just been released. Calcite also has adapters for CSV and JSON files, and JDBC data source, MongoDB, Spark and Splunk.