Function remove_over_expr

engine/src/parser/expression_utils.cpp:703–710

input: max_prices=[MAX($0) OVER (PARTITION BY $2 ORDER BY $0, $1)] output: max_prices=[MAX($0)]

// input: max_prices=[MAX($0) OVER (PARTITION BY $2 ORDER BY $0, $1)]
// output: max_prices=[MAX($0)]
std::string remove_over_expr(std::string expression) {

	std::string over_expression = get_over_expression(expression);
	std::string expression_to_remove = " OVER (" + over_expression + ")";
	std::string removed_expression = StringUtil::replace(expression, expression_to_remove, "");

	return removed_expression;
}

// Will replace the `COUNT($X)` expression with the right window col index
// useful when exists an `avg` or `sum` window expression