logan-keede commented on issue #16137:
URL: https://github.com/apache/datafusion/issues/16137#issuecomment-2907673352
https://github.com/apache/datafusion/blob/34f250a2b4800845b5c4e61bd928ddbbc4af7ba0/datafusion/expr/src/logical_plan/invariants.rs#L174-L201
DataFusion tries to pre
findepi opened a new issue, #16137:
URL: https://github.com/apache/datafusion/issues/16137
### Is your feature request related to a problem or challenge?
This is perfectly valid use of scalar subquery without aggregation.
This should work in DataFusion
```sql
WITH src AS