neilconway commented on code in PR #22672: URL: https://github.com/apache/datafusion/pull/22672#discussion_r3388891301
########## 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: We could, although I think this needs more discussion. We don't implement the exact SQL spec, of course -- we add extensions from places like DuckDB, Postgres, and so on, and there are major parts of the SQL spec that we also don't implement. I'm not sure if it will be helpful to users if we just reference the SQL spec. -- 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]
