We generally follow a subset of the MySQL SELECT statement syntax: https://dev.mysql.com/doc/refman/8.0/en/select.html