yoavcloud commented on issue #1607: URL: https://github.com/apache/datafusion-sqlparser-rs/issues/1607#issuecomment-2562220388
The underlying issue here is that when a column alias is provided implicitly, i.e. without the use of the `AS` keyword, the parser has to decide if the next word after a column ident is an alias or the beginning of some other construct that should be parsed differently. For example: `SELECT 1 LIMIT` on Snowflake produces a result set with one column named `limit`, but the statement `SELECT 1 LIMIT 5` produces a result set with one column named `1` (the limit is parsed as a limit on the number of rows in the result set). A possible solution is to make this decision more accurate. Instead of looking at just the next word, the parser should look further ahead to identify constructs that should not be parsed as an alias. -- 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-unsubscr...@datafusion.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org For additional commands, e-mail: github-h...@datafusion.apache.org
