In SurrealQL, clauses can be used to alter the way a query is executed. They are used in the following ways:
EXPLAIN: Explain the query plan.FETCH: Fetch all the fields of related records.FROM: Specify the table(s) or other target(s) to query from.GROUP: Group the results by a set of fields.LIMIT: Limit the number of results.OMIT: Omit related records.ORDER: Specify the sort order of the results.SPLIT: Split the results into a set of subqueries.START: Return the results of a query starting from a certain point.WHERE: Specify a condition that acts as a filter.WITH: Replace the default table iterator with an index iterator.