alamb opened a new issue, #10518: URL: https://github.com/apache/datafusion/issues/10518
### Is your feature request related to a problem or challenge? Part of https://github.com/apache/datafusion/issues/9726 to complete the Expr Converting `Expr` back to `SQL` is valuable for several usecases such as using DataFusion in federated databases (e.g. generate SQL to push down) or using DataFusion's expr APIs to programatically create SQL. ### Describe the solution you'd like Support converting SQL syntax like this: ```sql @foo ``` ### Describe alternatives you've considered The basic pattern is: 1. Implement the Expr --> AST reverse code in `Unparser::expr_to_sql`([source link](https://github.com/apache/datafusion/blob/16346022ed4564211c0fb4bf20ac165f2c481a90/datafusion/sql/src/unparser/expr.rs#L93-L94)) 3. Add a test to [`expr_to_sql_ok`](https://github.com/apache/datafusion/blob/16346022ed4564211c0fb4bf20ac165f2c481a90/datafusion/sql/src/unparser/expr.rs#L912-L913) Note you can run the tests like ```shell cargo test -p datafusion-sql -- expr_to_sql_ok ``` ### 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
