| 接口 | 说明 |
|---|---|
| FromItem |
An item in a "SELECT [...]
|
| FromItemVisitor | |
| IntoTableVisitor | |
| OrderByVisitor | |
| PivotVisitor | |
| SelectBody | |
| SelectItem |
Anything between "SELECT" and "FROM"
(that is, any column or expression etc to be retrieved with the query) |
| SelectItemVisitor | |
| SelectVisitor |
| 类 | 说明 |
|---|---|
| AllColumns |
All the columns (as in "SELECT * FROM ...")
|
| AllTableColumns | |
| Distinct |
A DISTINCT [ON (expression, ...)] clause
|
| ExceptOp | |
| ExpressionListItem | |
| Fetch |
A fetch clause in the form FETCH (FIRST | NEXT) row_count (ROW | ROWS) ONLY
|
| First |
A FIRST clause in the form [FIRST row_count] the alternative form [LIMIT row_count] is also
supported.
|
| FromItemVisitorAdapter | |
| FunctionItem | |
| IntersectOp | |
| IntoTableVisitorAdapter | |
| Join |
A join clause
|
| LateralSubSelect |
A lateral subselect followed by an alias.
|
| Limit |
A limit clause in the form [LIMIT {[offset,] row_count) | (row_count | ALL) OFFSET offset}]
|
| MinusOp | |
| Offset |
An offset clause in the form OFFSET offset or in the form OFFSET offset (ROW | ROWS)
|
| OrderByElement |
An element (column reference) in an "ORDER BY" clause.
|
| OrderByVisitorAdapter | |
| Pivot | |
| PivotVisitorAdapter | |
| PivotXml | |
| PlainSelect |
The core of a "SELECT" statement (no UNION, no ORDER BY)
|
| Select | |
| SelectExpressionItem |
An expression as in "SELECT expr1 AS EXPR"
|
| SelectItemVisitorAdapter | |
| SelectVisitorAdapter | |
| SetOperation |
Single Set-Operation (name).
|
| SetOperationList |
A database set operation.
|
| Skip |
A skip clause in the form [SKIP row_count]
Initial implementation was done for informix special syntax:
http://www-01.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.sqls.doc/ids_sqs_0156.htm
|
| SubJoin |
A table created by "(tab1 join tab2)".
|
| SubSelect |
A subselect followed by an optional alias.
|
| TableFunction | |
| Top |
A top clause in the form [TOP (row_count) or TOP row_count]
|
| UnionOp | |
| ValuesList |
This is a container for a values item within a select statement.
|
| Wait |
A timeout applied to SELECT to specify how long to wait for the row on the lock to be released.
|
| WithItem |
One of the parts of a "WITH" clause of a "SELECT" statement
|
| 枚举 | 说明 |
|---|---|
| First.Keyword | |
| OrderByElement.NullOrdering | |
| SetOperationList.SetOperationType |
list of set operations.
|