comphead commented on code in PR #22672: URL: https://github.com/apache/datafusion/pull/22672#discussion_r3377559356
########## docs/source/user-guide/sql/select.md: ########## @@ -19,76 +19,320 @@ # SELECT syntax -The queries in DataFusion scan data from tables and return 0 or more rows. -Please be aware that column names in queries are made lower-case, but not on the inferred schema. Accordingly, if you -want to query against a capitalized field, make sure to use double quotes. Please see this -[example](https://datafusion.apache.org/user-guide/example-usage.html) for clarification. -In this documentation we describe the SQL syntax in DataFusion. - -DataFusion supports the following syntax for queries: -<code class="language-sql hljs"> - -[ [WITH](#with-clause) with_query [, ...] ] <br/> -[SELECT](#select-clause) [ ALL | DISTINCT ] select_expr [, ...] <br/> -[ [FROM](#from-clause) from_item [, ...] ] <br/> -[ [JOIN](#join-clause) join_item [, ...] ] <br/> -[ [WHERE](#where-clause) condition ] <br/> -[ [GROUP BY](#group-by-clause) grouping_element [, ...] ] <br/> -[ [HAVING](#having-clause) condition] <br/> -[ [QUALIFY](#qualify-clause) condition] <br/> -[ [UNION](#union-clause) [ ALL | select ] <br/> -[ [ORDER BY](#order-by-clause) expression [ ASC | DESC ][, ...] ] <br/> -[ [LIMIT](#limit-clause) count ] <br/> -[ [EXCLUDE | EXCEPT](#exclude-and-except-clause) ] <br/> -[Pipe operators](#pipe-operators) <br/> - -</code> +Queries in DataFusion scan data from tables, subqueries, table functions, or Review Comment: Maybe we can just refer SQL standard, or at least trying to comply to SQL spec in https://jakewheat.github.io/sql-overview/sql-2008-foundation-grammar.html or WIKI? -- 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]
