See: Description
| Interface | Description |
|---|---|
| IExpressionVisitor |
TExpression
|
| Visitable |
| Class | Description |
|---|---|
| TAliasClause |
The column/table alias.
|
| TAlterDatabaseSqlNode | |
| TAlterFunctionSqlNode | |
| TAlterIndexSqlNode | |
| TAlterLibrarySqlNode | |
| TAlterSchemaSqlNode | |
| TAlterSequenceSqlNode | |
| TAlterTableOption |
Type of alter table option,
TAlterTableOption.getOptionType() returns the type of various option:
|
| TAlterTableOptionList |
alter table options
|
| TAlterTableSqlNode | |
| TAlterTriggerSqlNode | |
| TAlterViewSqlNode | |
| TAnalyticFunction | Deprecated
As of v1.8.6.3, replaced by
TWindowDef
Window/analytic clause of Window (or analytic) functions. |
| TArrayAccess |
array access of plsql.
|
| TAttributeOption |
Postgresql attribute_option = value
|
| TAutomaticProperty |
Automatic Initialization and Updating for TIMESTAMP in MySQL
|
| TBeginTranSqlNode | |
| TBindArgument |
Bind argument in using_clause of plsql execute_immediate_statement
|
| TBindArgumentList |
List of
TBindArgument |
| TBlockSqlNode | |
| TBreakSqlNode | |
| TCallSpec |
Call specification in PLSQL when define a function
|
| TCallSqlNode | |
| TCaseExpression |
CASE expressions let you use IF ...
|
| TCloseSqlNode | |
| TCollectStatisticsSqlNode | |
| TColumnAttribute | |
| TColumnAttributes | |
| TColumnDefinition |
Define the characteristics of the column.
|
| TColumnDefinitionList | |
| TColumnReference |
TColumnReference represents column, variable, function/procedure parameter
|
| TColumnReferenceList | |
| TColumnWithSortOrder | |
| TCommentSqlNode | |
| TCompoundDmlTriggerClause |
Use this clause to define a compound trigger on a DML event.
|
| TCompoundSqlNode |
DB2 procedure compound statement
|
| TComputeClause |
SQL Server compute clause, including a list of compute clause item which is in syntax:
COMPUTE [compute_expr_list] [BY by_expr_list]
|
| TComputeClauseItem |
SQL Server compute clause item
|
| TComputeClauseItemList | Deprecated
As of v1.8.7.2, replaced by
TPTNodeList |
| TComputeExpr | |
| TComputeExprList | |
| TConnectByClause | |
| TConnectSqlNode | |
| TConstant |
SQL constant (sometimes called a literal) specifies a value.
|
| TConstantList | |
| TConstraint |
Use a constraint to define an integrity constraint, a rule that restricts the values in a database.
|
| TConstraintList |
List of
TConstraint. |
| TContainsTable | |
| TContinueSqlNode | |
| TCreateDatabaseSqlNode | |
| TCreateDirectorySqlNode | |
| TCreateFunctionSqlNode |
Internal use in the parser..
|
| TCreateIndexSqlNode | |
| TCreateMaterializedViewLogSqlNode | |
| TCreateMaterializedViewSqlNode | |
| TCreatePackageSqlNode |
Internal use in the parser..
|
| TCreateProcedureSqlNode |
Internal use in the parser.
|
| TCreateRowTypeSqlNode | |
| TCreateSchemaSqlNode | |
| TCreateSequenceSqlNode | |
| TCreateSynonymSqlNode | |
| TCreateTableSqlNode | |
| TCreateTriggerSqlNode |
Internal use in the parser.
|
| TCreateUserSqlNode | |
| TCreateViewSqlNode | |
| TCTE |
A common table expression permits defining a result table with a table-name that can be specified as a table name in any FROM clause of the fullselect that follows.
|
| TCTEList |
Collections of
TCTE. |
| TDatabaseEventClause | |
| TDatabaseEventItem | |
| TDataChangeTable |
DB2 data change table
|
| TDatatypeAttribute |
datatype attributes supported in various databases.
|
| TDatatypeAttributeList | |
| TDatetimeExpression | |
| TDdlEventClause |
Created by Tako on 2019/7/30.
|
| TDdlEventItem | |
| TDeclareSqlNode | |
| TDeclareVariable |
SQL Server declare variable
|
| TDeclareVariableList |
List of declare variable
|
| TDeleteSqlNode | |
| TDenySqlNode | |
| TDescribeSqlNode | |
| TDmlEventClause |
The DML_event_clause lets you specify one of three DML statements that can cause the trigger to fire.
|
| TDmlEventItem |
Create trigger dml event: delete, insert, update [of columns]
|
| TDmlSelectItem | |
| TDmlSelectItemList |
used in sql server dml select list
|
| TDropDatabaseSqlNode | |
| TDropDbObjectSqlNode | |
| TDropIndexItem | |
| TDropIndexItemList | |
| TDropIndexSqlNode | |
| TDropProcedureSqlNode | |
| TDropSchemaSqlNode | |
| TDropSequenceSqlNode | |
| TDropTableSqlNode | |
| TDropViewSqlNode | |
| TDummy | |
| TDummyList | |
| TElseIfSqlNode | |
| TElseIfSqlNodeList | |
| TEndTranSqlNode | |
| TExceptionClause |
Including a list of
TExceptionHandler that process raised exceptions. |
| TExceptionHandler |
An exception handler processes a raised exception.
|
| TExceptionHandlerList | |
| TExecImmeNode |
Internal used by parser.
|
| TExecParameter |
Parameter of execute statement in SQL Server,teradata
|
| TExecParameterList | |
| TExecuteAsSqlNode | |
| TExecuteSqlNode | |
| TExplicitDataTypeConversion | |
| TExpression |
An expression is a combination of one or more values, operators, and SQL functions that evaluates to a value.
|
| TExpressionCallTarget |
SQL Server value() Method performs an XQuery against the XML and returns a value of SQL type.
|
| TExpressionList | |
| TFetchFirstClause |
DB2 fetch first clause.
|
| TFetchSqlNode |
fetch ..
|
| TFlashback | |
| TForSqlNode | |
| TForUpdate |
The FOR UPDATE clause lets you lock the selected rows so that other users cannot lock
or update the rows until you end your transaction.
|
| TFrameExclusionClause | |
| TFromTable |
Represents table source in from clause of select/delete statement, and update table clause of update statement.
|
| TFromTableList | |
| TFunctionCall |
Represents the database function, all functions are represented by this class no matter what's type of the function.
|
| TGrantSqlNode | |
| TGroupBy |
This class represents group by clause and having clause.
|
| TGroupByItem | |
| TGroupByItemList | |
| TGroupingExpressionItem | Deprecated
As of v1.4.3.3, replaced by
TExpression |
| TGroupingExpressionItemList | Deprecated
As of v1.4.3.3, replaced by
TExpressionList |
| TGroupingSet |
GROUPING SETS are a further extension of the GROUP BY clause that let you specify multiple groupings of data.
|
| TGroupingSetItem |
Gruping set item that used in TGroupingSet
Content of this item can be a TRollupCube instance or a TGroupingExpressionItem instance
|
| TGroupingSetItemList |
Grouping set item list in TGroupingSet.
|
| THierarchical |
Oracle hierarchical_query_clause lets you select rows in a hierarchical order.
|
| THintClause |
Hint clause in Hana
|
| TIfSqlNode | |
| TIncludeColumns | |
| TIndexColName | Deprecated
as V1.8.7.2, replaced by
TColumnWithSortOrder |
| TIndices |
Postgresql;
|
| TIndirection |
Postgresql, redshift
|
| TInExpr | Deprecated
As of v1.4.3.3, replaced by
TExpression |
| TInformixOuterClause | |
| TInsertCondition | |
| TInsertIntoValue | |
| TInsertSqlNode |
Interal used by parser.
|
| TIntervalExpression | |
| TIntoClause | |
| TIntoTableClause |
Informix, into table clause.
|
| TIsolationClause |
DB2/Sybase isolation clause
|
| TJoin |
A list of join
TCustomSqlStatement.joins represents table sources in following clauses of SQL statement:
from clause of select statement.
from clause of delete statement, Specifies an additional FROM clause, This Transact-SQL extension to DELETE allows specifying data from table_source and deleting the corresponding rows from the table in the first FROM clause.
from clause of update statement, Specifies that a table, view, or derived table source is used to provide the criteria for the update operation. |
| TJoinExpr |
Internal used by parser.
|
| TJoinItem |
SQL 1:
|
| TJoinItemList | |
| TJoinList | |
| TKeepDenseRankClause |
Oracle keep dense rank clause used in analytic function.
|
| TKeyAction | |
| TKeyReference | |
| TLimitClause | |
| TLockingClause |
Postgresql locking clause
|
| TLockingClauseList | |
| TLockSqlNode | |
| TLoopSqlNode | |
| TMergeDeleteClause | |
| TMergeInsertClause |
insert clause in merge statement.
|
| TMergeSqlNode | |
| TMergeUpdateClause |
update clause in merge statement.
|
| TMergeWhenClause |
when [not] matched clause in merge statement.
|
| TMultiTarget |
Represents value list in value clause of insert statement.
|
| TMultiTargetList |
List of TMultiTarget which can be used in values clause of insert statement.
|
| TMySQLCreateTableOption | |
| TMySQLIndexStorageType | |
| TNameValuePair | |
| TNewVariantTypeArgument | |
| TNewVariantTypeArgumentList | |
| TNodeFactory | |
| TNodeWithAliasClause | |
| TNonDmlTriggerClause |
Use this clause to define a single trigger on a DDL or database event.
|
| TObjectAccess |
An object access expression specifies attribute reference and method invocation.
|
| TObjectName |
The qualified or unqualified name that identifies a database object.
|
| TObjectNameList |
List of TObjectName
|
| TObjectReference | |
| TObjectReferenceList |
Created by IntelliJ IDEA.
|
| TOffsetClause |
PostgreSQL offset clause in select limit
Oracle offset clause in select |
| TOpenDatasource | |
| TOpenQuery | |
| TOpenRowSet | |
| TOpenSqlNode | |
| TOpenXML | |
| TOptimizeForClause |
DB2 Optimize for clause
|
| TOrderBy |
List of order by item which is type of
TOrderByItem. |
| TOrderByItem |
Item in order by clause.
|
| TOrderByItemList | |
| TOutputClause | |
| TOutputFormatPhrase | Deprecated
As of v1.4.9.8, use TExplicitDataTypeConversion instead
teradata output format phrase
|
| TOutputFormatPhraseList | Deprecated
As of v1.4.9.8, use TExplicitDataTypeConversion with instead
|
| TParameterDeclaration |
Parameters in create procedure/function statements.
|
| TParameterDeclarationList |
List of
TParameterDeclaration. |
| TParameterMode | |
| TParseErrorSqlNode | |
| TParseTreeNode |
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeNodeList |
List of parse tree node.
|
| TParseTreeVisitor | |
| TPartitionByClause | Deprecated
As of v1.8.6.0, replaced by
TPartitionClause |
| TPartitionClause | |
| TPartitionExtensionClause | |
| TPivotClause |
use the PIVOT and UNPIVOT relational operators to change a table-valued expression into another table.
|
| TPivotedTable | |
| TPivotInClause | |
| TPrecisionScale | |
| TPTNodeList<E> | |
| TPxGranule | |
| TQualifyClause |
teradata qualify clause
|
| TQueryHint | |
| TRelationExpr |
Postgresql Relation expr parse tree node
|
| TRelationExprList | |
| TRepeatSqlNode | |
| TRestrictionClause |
Oracle, DB2 restrict clause in create view statement
|
| TResultColumn |
This class represents select_list item in select statement, lets you specify the columns you want to retrieve from the table.
|
| TResultColumnList | |
| TReturningClause | |
| TReturnSqlNode | |
| TRevokeSqlNode | |
| TRollupCube |
The ROLLUP operation in the simple_grouping_clause groups the selected rows based on the values of the first n, n-1, n-2, ...
|
| TSampleClause | |
| TSelectDistinct | |
| TSelectSqlNode |
Internal used by parser, reprsents raw parse tree node of select statement.
|
| TSequenceOption | |
| TSetAssignment | |
| TSetSqlNode | |
| TSimpleDmlTriggerClause | |
| TStatementListSqlNode | |
| TStatementSqlNode | |
| TStubStmtSqlNode | |
| TSubscripts | |
| TSymbolTableItem | |
| TTable |
Represents various kinds of table source in from clause.
|
| TTableElement | |
| TTableElementList | |
| TTableHint |
SQL Server table hint:
|
| TTableList | |
| TTableReference | |
| TTableReferenceList | |
| TTableSample | |
| TTableSamplePart | |
| TTeradataWithClause | |
| TTeradataWithClauseItem | |
| TTeradataWithClauseItemList | |
| TTopClause |
Indicates that only a specified first set or percent of rows will be returned from the query result set.
|
| TTriggerAction | |
| TTriggerEventClause |
One of these 3 event clauses:
dml event clause, ddl event clause, database event clause
subclass:
TDmlEvenClause, TDdlEventClause, TDatabaseEventClause
|
| TTriggerEventItem |
Including 3 types:
TDmlEventItem, TDdlEventItem, TDatabaseEventItem
|
| TTriggeringClause |
Trigger clause including:
action time: before, after, instead of
event type: insert, delete, update, ddl event, database event,
TDmlEventClause
referencing clause: old, new ,parent
There are 3 types of triggering clause: simple dml, compound dml, non-dml. |
| TTriggerReferencingClause | |
| TTriggerReferencingItem | |
| TTrimArgument |
Argument of trim function.
|
| TTruncateTableSqlNode | |
| TTypeAttribute |
Attribute definition of an object type(
TPlsqlCreateType) |
| TTypeAttributeList |
List of attribute definition (
TTypeAttribute) of an object type. |
| TTypeName |
This class represents SQL Datatype.
|
| TTypeNameList | |
| TUnpivotInClause | |
| TUnpivotInClauseItem | |
| TUpdateSqlNode | |
| TValueClause | |
| TValueRowItem | |
| TValueRowItemList | |
| TVarDeclStmt |
Represents declare statement that used to decalre variable, constant, exception and subtype.
|
| TViewAliasClause | |
| TViewAliasItem | |
| TViewAliasItemList | |
| TWhenClauseItem |
WhenClause item used in case expr of
TCaseExpression. |
| TWhenClauseItemList |
List of
TWhenClauseItem |
| TWhereClause | |
| TWhileSqlNode | |
| TWindowClause | |
| TWindowDef |
Represents over clause in analytic function.
|
| TWindowDefinition | Deprecated
As of v1.8.6.0, replaced by
TWindowDef |
| TWindowFrame | |
| TWindowFrameBoundary | |
| TWindowPartitioningSpec | |
| TWindowSpecification | Deprecated
As of v1.8.6.0, replaced by
TWindowDef |
| TWithinGroup |
Oracle within group clause used in analytic function
|
| TWithTableLock |
Openedge with clause in select statement.
|
| TXmlElement | |
| TXmlRoot | |
| TXmlSerialize | |
| TXmlTable | |
| TXmlTableParameter |
| Enum | Description |
|---|---|
| ENodeType |
Type of parse tree node
|
| TAttributeOption.EValueType | |
| TForUpdate.EForUpdateType |
Typically, SQL parse tree nodes generated by this SQL Parser were closely related to SQL elements defined in database vendor's SQL reference book. here is a brief summary of some most used SQL elements and corresponding classes defined in this SQL parser.
TObjectNameTConstantTTypeNameTFunctionCallTConstraintTExpressionTResultColumnRelated class for a specific SQL element can always be found via the path: SQL statement -> SQL clause -> SQL element
Copyright © 2019. All rights reserved.