You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@datafusion.apache.org by "rkrishn7 (via GitHub)" <gi...@apache.org> on 2025/08/31 06:44:22 UTC
[I] Friendlier SQL in `SELECT` and `WHERE` [datafusion]
rkrishn7 opened a new issue, #17361:
URL: https://github.com/apache/datafusion/issues/17361
### Is your feature request related to a problem or challenge?
In the spirit of making SQL a bit more [friendly](https://duckdb.org/docs/stable/sql/dialect/friendly_sql.html) in DF, we can allow aliases in a few more places.
### Describe the solution you'd like
Take a bit more inspiration from DuckDB's Friendly SQL. Specifically:
- Support lateral column aliases (e.g.: `SELECT a AS b, b + 1 AS c FROM t`)
- Support column aliases in `WHERE` (we already do this in `HAVING`, `GROUP BY`, etc.)
### Describe alternatives you've considered
_No response_
### Additional context
_No response_
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org
Re: [I] Friendlier SQL in `SELECT` and `WHERE` [datafusion]
Posted by "rkrishn7 (via GitHub)" <gi...@apache.org>.
rkrishn7 commented on issue #17361:
URL: https://github.com/apache/datafusion/issues/17361#issuecomment-3239827232
take
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org
Re: [I] Friendlier SQL in `SELECT` and `WHERE` [datafusion]
Posted by "rkrishn7 (via GitHub)" <gi...@apache.org>.
rkrishn7 commented on issue #17361:
URL: https://github.com/apache/datafusion/issues/17361#issuecomment-3259414542
@alamb What are your thoughts on this? If it makes sense to you, happy to drive the draft PR up I have home (should just need some tests).
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org
Re: [I] Friendlier SQL in `SELECT` and `WHERE` [datafusion]
Posted by "alamb (via GitHub)" <gi...@apache.org>.
alamb commented on issue #17361:
URL: https://github.com/apache/datafusion/issues/17361#issuecomment-3271503236
in general I am focused on improving the existing functionality / performance, rather than adding new functionality to datafusion
If enough users are interested in this feature, it seems like a good idea to me. But if it is just one or two then probably not
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org