- Features - Recursive CTE - LIMIT - Prepare & execute statements - Array/Unnest functionality - Decimals - Insert statement - PRs - [feat: support unnest multiple arrays #10044](https://github.com/apache/datafusion/pull/10044) - [fix: detect non-recursive CTEs in the recursive WITH clause #9836](https://github.com/apache/datafusion/pull/9836) - [feat: support arbitrary expressions in LIMIT plan #13028](https://github.com/apache/datafusion/pull/13028) - [feat: basic support for executing prepared statements #13242](https://github.com/apache/datafusion/pull/13242) - [feat: parse_float_as_decimal supports scientific notation and Decimal256 #13806](https://github.com/apache/datafusion/pull/13806/) - [refactor: use a common macro to define math UDFs #9598](https://github.com/apache/datafusion/pull/9598) - [fix: make columnize_expr resistant to display_name collisions #10459](https://github.com/apache/datafusion/pull/10459) - Resolved the long-standing issue of column name ambiguity, which impacts the correctness of projections and aliases. - [fix: schema error when parsing order-by expressions #10234](https://github.com/apache/datafusion/pull/10234) - [fix: move coercion of union from builder to TypeCoercion #11961](https://github.com/apache/datafusion/pull/11961) - Issues: Some subtle edge cases I have discovered - [WITH RECURSIVE clause may define non-recursive CTEs #9804](https://github.com/apache/datafusion/issues/9804) - [CTE in a UNION query can escape its scope #10914](https://github.com/apache/datafusion/issues/10914) - [UnwrapCastInComparison produces incorrect results #14303](https://github.com/apache/datafusion/issues/14303) - [Find a safe alternative to LogicalPlan using_columns #14118](https://github.com/apache/datafusion/issues/14118) - [Probably incorrect result when the column referenced in GROUP BY is ambiguous #9162](https://github.com/apache/datafusion/issues/9162) - [Conflicting optimization rules: common_sub_expression_eliminate and push_down_projection #8296](https://github.com/apache/datafusion/issues/8296)