Method execute_with_clause_simple

graphlite/src/exec/executor.rs:1404–1435

ROADMAP v0.5.0 - Alternative WITH clause implementation

(
        &self,
        with_clause: &WithClause,
        input_rows: Vec<Row>,
        context: &ExecutionContext,
    )

    /// Execute a WITH clause without aggregation (fallback for simple cases)
    #[allow(dead_code)] // ROADMAP v0.5.0 - Alternative WITH clause implementation
    fn execute_with_clause_simple(
        &self,
        with_clause: &WithClause,
        input_rows: Vec<Row>,
        context: &ExecutionContext,
    ) -> Result<Vec<Row>, ExecutionError> {
        // Debug output for WITH clause variable scoping issues
        // log::debug!("DEBUG: execute_with_clause_simple called with {} input rows", input_rows.len());
        log::debug!("Executing simple WITH clause (no aggregation)");

        // Transform each row according to WITH items
        let mut result_rows = Vec::new();

        for input_row in input_rows {
            let mut output_row = Row::new();

            // Evaluate each WITH item
            for with_item in &with_clause.items {
                let value =
                    self.evaluate_expression_in_row(&with_item.expression, &input_row, context)?;
                let var_name = with_item.alias.clone().unwrap_or_else(|| {
                    // Generate default name if no alias provided
                    format!("col_{}", output_row.values.len())
                });
                output_row.add_value(var_name, value);
            }

            result_rows.push(output_row);
        }

        Ok(result_rows)
    }

    /// Execute WITH clause by routing through WithClauseProcessor (comprehensive consolidation approach)
    fn execute_with_clause_via_processor(