Improving Document about SELECT clause. about jet HOT 3 CLOSED

Hi @Q00 ,
There are already couple of examples for multiple conditions. For instance on the main Readme page, faq example and in Expressions. You can also search tests for more examples.
Maybe we can add one more example for global AND and OR functions inside Logical operators. I don't think SELECT section needs to be updated. SELECT section is just to list the supported clauses.

from jet.

You can find more info about expressions here: https://github.com/go-jet/jet/wiki/Expressions.
Also, SQL doesn't support multiple WHERE clauses, it has to be only one.

from jet.

You can find more info about expressions here: https://github.com/go-jet/jet/wiki/Expressions. Also, SQL doesn't support multiple WHERE clauses, it has to be only one.

@houten11
Thank you for your prompt response. I understand that SQL does not support multiple WHERE clauses; rather, it uses a single WHERE clause with multiple conditions combined using AND, OR, etc. My concern is specifically about the lack of examples and explanations regarding this common usage in the SELECT documentation.

The SELECT section does not currently include examples or descriptions of how to use multiple conditions in the WHERE clause. There is an example in the Subquery section that uses AND, but it would be beneficial to have this information readily available in the SELECT documentation as well. Users often need to construct queries with multiple conditions, and having this information in the relevant section would make it easier for them to find and understand.

cc. @go-jet

from jet.