When true, slow-performing queries are processed on the server.
Cassandra by default does not allow filtering for queries that it predicts will have performance problems. These queries include filtering on a column that is not the primary key. When SupportEnhancedSQL is enabled, the driver parses queries in memory with the SQL engine, instead of offloading processing of the query to the database.
You can override the default behavior and rely on the server to process these queries by setting AllowFiltering to true.