Method can_use_read_only_optimization

src/optimization/read_only_optimizer.rs:149–180

Check if a query can use read-only optimization

(&self, query: &str)

    /// Check if a query can use read-only optimization
    fn can_use_read_only_optimization(&self, query: &str) -> bool {
        let query_upper = query.to_uppercase();
        
        // Must be a SELECT query
        if !query_upper.trim().starts_with("SELECT") {
            return false;
        }

        // Exclude complex queries that need full processing
        if query_upper.contains("JOIN") ||
           query_upper.contains("UNION") ||
           query_upper.contains("SUBQUERY") ||
           query_upper.contains("WITH") ||
           query_upper.contains("CASE") ||
           query_upper.contains("WINDOW") ||
           query_upper.contains("RECURSIVE") {
            return false;
        }

        // Exclude queries with functions that might need translation
        if query_upper.contains("NOW()") ||
           query_upper.contains("CURRENT_TIMESTAMP") ||
           query_upper.contains("CURRENT_DATE") ||
           query_upper.contains("CURRENT_TIME") ||
           query_upper.contains("::") ||  // Type casts
           query_upper.contains("EXTRACT") ||
           query_upper.contains("DATE_TRUNC") {
            return false;
        }

        true
    }

    /// Generate a normalized cache key for the query
    fn generate_cache_key(&self, query: &str) -> String {