Class 

Description 

TAccessParameters 

Class represents for Parameters Declaration 

TCustomGSqlParser 

SQL Parser class. 

TGSqlParser 

SQL Parser class. 

TLz_AliasClause 

Represent alias of table of field. 

TLz_AnalyticFunction 

Class represent analytic function. 

TLz_Attr 

TLz_Attr represents a dot separated name, or just a single name.
Usually, it represents a database object like table, field, function name, etc...

relname is the first source token of identifier.
Take identifier: server.database.schema_name.object_name for example, relname points to "server".

attrs stores source tokens in identifier except first one. Take identifier: server.database.schema_name.object_name for example, attrs includes "database",
"schema_name", and "object_name".

If identifier is a single name like this: object_name, then relname stores source token of object_name, and attrs is empty.

If attr is a dot separated name like this: schema_name.object_name, then relname -> schema_name , and attrs[0] -> object_name.... more 

TLz_CastArg 

Argument of cast function used in TLz_FuncCall. 

TLz_Const 

TLz_Const represents a parse tree node of const value including integer, float and single quote string. 

TLz_DummyNode 

Dummy node to store information of various parse tree node. 

TLz_FuncCall 

Class represents function call. 

TLz_Ident 

Identifier in sql was represented by TLz_Attr, so this class is not used. 

TLz_InsertStmt 

Raw parse tree node of insert statement. 

TLz_JoinExpr 

Raw parse tree of join table. All information in this node will be parsed into TlzJoin. 

TLz_JoinQual 

Raw parse tree node of join condition. 

TLz_List 

List of objects which is type of TLz_Node, or class descends from TLz_Node. 

TLz_Node 

Base class of all parse tree nodes. 

TLz_ResTarget 

Raw parse tree node of select list item. 

TLz_SortGroupBy 

Raw parse tree node of order by clause. 

TLz_TableRef 

Raw parse tree node of data source, usually, it's a table. 

TLz_TypeName 

Represent various data type used in sql. 

TLz_UpdateStmt 

Raw parse tree node of update statement. 

TLz_ValueClause 

Value clause of DB2. 

TLzColumnDef 

Raw parse tree node of column in create/alter table. 

TLzConstraint 

Constraint of column and table level. 

TLzConstraintList 

List of constraint. 

TLzConstraintRefClause 

Reference clause of foreign key. 

TLzCTE 

Represents common table expression. 

TLzCustomExpression 

Expression is widely used in the sql, such as in the where clause,having clause. It's represented by the class TLzCustomExpression, and organized in a binary tree mode.

Usually, expression is created after parsing a sql.
You can also create expression manually in two ways:
1. Create an empty TLzCustomExpression instance, and
than add lexpr, rexpr and set oper yourself.

2. Create a TLzCustomExpression instance with an expression string as paramter, than a binary expression
tree will be created automatically with lexpr, rexpr,
oper and other properties set correctly if input expression string is a valid expression.

You... more 

TLzDBObject 

Database object tokens in TCustomSqlStatement such as ServerTokens,DatabaseTokens,SchemaTokens,TableTokens store full original information, it's grouped by each sql statement, and not sorted, same object may occurs serval time. Sometimes, we want to access these database objects in a script level, group by server,database,schema,with sourted information.

So, we prepare all these raw information in TCustomSqlStatement into a new class: TLzDBObject, along with TLzDBObjectList,
you have a more convenience way to access database object in sql scripts.
 

TLzDBObjectList 

List of database object found in sql. 

TLzField 

Field/Column in all sql statements. 

TLzFieldList 

List of TlzField. 

TLzFmtOpt 

Class used to setup format options. 

TLzJoin 

Elements in from clause were represented by one or more TLzJoin objects.



Theta joins, which use the WHERE clause to establish the filtering criteria, are the "old" way to do join operations.
In such type of join, each table in from clause have a corresponding TlzJoin object with JoinTableType = jttNone

 

TLzJoinItem 

In from clause, one table can connect to previous table.
Join item contains all information about this connection such as table(JoinItemTable, JoinItemJoin), join type(JoinType), join condition(JoinQualType, JoinQual).

 

TLzJoinItemList 

List of join item in join. 

TLzJoinList 

List of Joins in from clause. 

TLzNode 

Placeholder of TLz_Node. 

TLzStatementList 

List of sql statement, all descends from TCustomSqlStatement. 

TLzTable 

Represents table object in sql. 

TLzTableList 

List of tables. 

TLzTopClause 

Top clause of ms sql server. 

TLzValue 

Class used to store bind variable(:bindvar) and sql variable (@var).

When a bind variable was found, TCustomGSqlParser.OnBindVar is fired.

When a sql variable was found, TCustomGSqlParser.OnSqlVar is fired.

Bind variable can be found in TCustomSqlStatement.Params.

Sql variable can be found in TCustomSqlStatement.SqlVars. 

TLzValueList 

List of value list. 

TSourceToken 

Source token created after reading from input sql.

If this token represents a database object, check following properties for more detail information.

TSourceToken.DBObjType
TSourceToken.ParentToken
TSourceToken.ChildToken
TSourceToken.RelatedToken
TSourceToken.RelatedTokens
TSourceToken.RelatedSubquery 

TSourceTokenList 

List of source tokens. 

Module 

Description 

Common SQL Statement Classes 

 

SQL Server Related Classes 

 

Oracle Related Classes 

 

DB2 Related Classes 

 

MySQL Related Classes