Package gudusoft.gsqlparser.nodes
package gudusoft.gsqlparser.nodes
Provides the classes represents various SQL query parse tree node.
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.
- SQL identifier:
TObjectName - SQL literal:
TConstant - SQL datatype:
TTypeName - SQL function:
TFunctionCall - SQL constraint:
TConstraint - SQL expression/condition:
TExpression - SQL select list item:
TResultColumn
Related class for a specific SQL element can always be found via the path: SQL statement -> SQL clause -> SQL element
- Since:
- 1.0
-
ClassDescriptionType of parse tree nodeTExpressionThe column/table alias.Type of alter table option,
TAlterTableOption.getOptionType()returns the type of various option:alter table optionsDeprecated.array access of plsql.Postgresql attribute_option = value #Todo: this class needs to be replaced byTNameValuePairlaterAutomatic Initialization and Updating for TIMESTAMP in MySQLBase partition of all table partitions, such as range_partitions, list_partitions, hash_partitions,composite_range_partitions and etcBind argument in using_clause of plsql execute_immediate_statementList ofTBindArgumentTBlockSqlNode represents a block in a stored procedure.Call specification in PLSQL when define a functionCASE expressions let you use IF ...SAP hana case join clause.SAP hana case join when item.property of character data type, such as character set name, case specific.Define the characteristics of the column.TColumnReference represents column, variable, function/procedure parameterRepresents db2,oracle comment on statement.Use this clause to define a compound trigger on a DML event.DB2 procedure compound statementSQL Server compute clause, including a list of compute clause item which is in syntax: COMPUTE [compute_expr_list] [BY by_expr_list]SQL Server compute clause itemDeprecated.As of v1.8.7.2SQL constant (sometimes called a literal) specifies a value.Use a constraint to define an integrity constraint, a rule that restricts the values in a database.List ofTConstraint.Internal use in the parser..Internal use in the parser..Internal use in the parser.Internal use in the parser.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.Collections ofTCTE.DB2 data change tabledatatype attributes supported in various databases.Created by Tako on 2019/7/30.SQL Server declare variableList of declare variableThe DML_event_clause lets you specify one of three DML statements that can cause the trigger to fire.Create trigger dml event: delete, insert, update [of columns]used in sql server dml select listIncluding a list ofTExceptionHandlerthat process raised exceptions.An exception handler processes a raised exception.Internal used by parser.Parameter of execute statement in SQL Server,teradataAn expression is a combination of one or more values, operators, and SQL functions that evaluates to a value.SQL Server value() Method performs an XQuery against the XML and returns a value of SQL type.DB2 fetch first clause.fetch ..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.Represents table source in from clause of select/delete statement, and update table clause of update statement.Represents the database function, all functions are represented by this class no matter what's type of the function.A structure includes function name and argumentsThis class represents group by clause and having clause.Deprecated.As of v1.4.3.3, replaced byTExpressionDeprecated.As of v1.4.3.3, replaced byTExpressionListGROUPING SETS are a further extension of the GROUP BY clause that let you specify multiple groupings of data.Gruping set item that used in TGroupingSet Content of this item can be a TRollupCube instance or a TGroupingExpressionItem instanceGrouping set item list in TGroupingSet.Teradata handler for clauseOracle hierarchical_query_clause lets you select rows in a hierarchical order.Hint clause in HanaColumn identity clause.Deprecated.as V1.8.7.2, replaced byTColumnWithSortOrderRepresents indirection elements in SQL expressions, supporting both array access and qualified name syntax.Enum to distinguish between array access syntax and qualified name syntax.Postgresql, redshiftDeprecated.As of v1.4.3.3, replaced byTExpressionInteral used by parser.Informix, into table clause.DB2/Sybase isolation clauseDeprecated.As of v2.7.4.0, Please useTJoinExprinstead.Represents a JOIN expression in SQL statements.Deprecated.As of v2.7.4.0, Please useTJoinExprinstead.This class is used to represent a JSON_TABLE function in Oracle and OpenJson function in SQL Server.Oracle keep dense rank clause used in analytic function.list values clause in hash partitionsPostgresql locking clauseinsert clause in merge statement.update clause in merge statement.when [not] matched clause in merge statement.Represents a row in value clause of insert statement, or a row in values clause.Represents one or more rows in the values clause of insert statement, or in the values() clause.Use this clause to define a single trigger on a DDL or database event.An object access expression specifies attribute reference and method invocation.The qualified or unqualified name that identifies a database object.List of TObjectNameCreated by IntelliJ IDEA.PostgreSQL offset clause in select limit
Oracle offset clause in selectDB2 Optimize for clauseList of order by item which is type ofTOrderByItem.Item in order by clause.Deprecated.As of v1.4.9.8, use TExplicitDataTypeConversion instead teradata output format phraseDeprecated.As of v1.4.9.8, use TExplicitDataTypeConversion with insteadParameters in create procedure/function statements.List ofTParameterDeclaration.TParseTreeNode - Core Parse Tree Node ImplementationTParseTreeNodeList<T extends TParseTreeNode>List of parse tree node.Deprecated.As of v1.8.6.0, replaced byTPartitionClauseused in window functionPartition definition in syntax like:Hive, Impala, MySQL, Oracle partition clause in from tableSnowflake path object, usually used in stage referenceuse the PIVOT and UNPIVOT relational operators to change a table-valued expression into another table.TPTNodeList<E>teradata qualify clauserange values clause in range partitionsPostgresql Relation expr parse tree nodeOracle, DB2 restrict clause in create view statementThis class represents select_list item in select statement, lets you specify the columns you want to retrieve from the table.The ROLLUP operation in the simple_grouping_clause groups the selected rows based on the values of the first n, n-1, n-2, ...Internal used by parser, reprsents raw parse tree node of select statement.Oracle subpartition type of composite_range_partitionsRepresents various kinds of table source in from clause.SQL Server table hint:#TODO Need to be merged intoTPartitionDefinitionOracle table propertiesIndicates that only a specified first set or percent of rows will be returned from the query result set.One of these 3 event clauses: dml event clause, ddl event clause, database event clause subclass: TDmlEvenClause, TDdlEventClause, TDatabaseEventClauseIncluding 3 types: TDmlEventItem, TDdlEventItem, TDatabaseEventItemTrigger clause including: action time: before, after, instead of event type: insert, delete, update, ddl event, database event,TDmlEventClausereferencing clause: old, new ,parent There are 3 types of triggering clause: simple dml, compound dml, non-dml.Argument of trim function.Attribute definition of an object type(TPlsqlCreateType)List of attribute definition (TTypeAttribute) of an object type.This class represents SQL Datatype.represents values() clause.Deprecated.As of v2.3.6.9, please useTMultiTargetinsteadDeprecated.As of v2.3.6.9, please useTMultiTargetListinsteadWhenClause item used in case expr ofTCaseExpression.List ofTWhenClauseItemRepresents over clause in analytic function.Deprecated.As of v1.8.6.0, replaced byTWindowDefDeprecated.As of v1.8.6.0, replaced byTWindowDefOracle within group clause used in analytic functionOpenedge with clause in select statement.Created by tako on 2015/1/20.
TWindowDefWindow/analytic clause of Window (or analytic) functions.