SQL clause structure - sqlparser/sql-pretty-printer GitHub Wiki

SQL statement is made up of different clauses. For example, SELECT statement consist of select list, from clause, where clause, group by and etc. Each clause has same structure like this:

  <MAIN KEYWORD> [options] <arguments>

Take this select list for example:

  SELECT top 10 name, department, location

SELECT is main keyword, top 10 is option, name, department, location is arguments.

WHERE salary > 1000

WHERE is main keyword, salary > 1000 is argument.