Uses of Package
gudusoft.gsqlparser
Packages that use gudusoft.gsqlparser
Package
Description
Provides the class
TGSqlParser necessary to create a SQL Parser and the classes a SQL Parser uses
internally to handle different SQL dialects.Provides the classes represents various SQL query parse tree node.
Provides the classes represent various SQL statements.
-
Classes in gudusoft.gsqlparser used by Unnamed PackageClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.Represents a source token which is the basic syntactic unit of SQL. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparserClassDescriptionUsed by parser internally.subtype of alter column in alter table statement.Teradata datatype attributeDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.Type of SQL syntax errors.SQL Server execute as option
scalar expression: return a single value.Used by parser internally.source of insert valueType ofTConstantquery hint typeSpecifies which SQL resolver to use for name resolution during parsing.Oracle/DB2 create view, subquery restriction clauseUsed to replace TBaseType.srtNone,srtAsc and srtDescEnum for various SQL clause such as where clause, having clause and etc.Type of SQL statement.Used by parser internally.Type of source token.A specification that indicates when triggered SQL statements perform in relation to the triggering event.Deprecated.This is the interface for handling SQL statements after parsing each SQL statement.use this interface if you like to change token properties generated by lexer before send to parser.
if you change a source token's TSourceToken#tokencode to TBaseType#cmtslashstar TBaseType#cmtdoublehyphen then, this token will be treated as comment
you may also like to change tokencode of a keyword to TBaseType#ident, this will let parser treat this keyword as an identifier.TAttributeNode 类似 column,但含义更广泛。用来表示 SQL 语句中 table 包含的字段(table 或许用 relation 更准确)。 这里的 table 可以是数据库的基本表,也可以是 from clause 中出现的子查询,或者是 CTE。 GSP 会把 SQL 语句中出现的每个 table 都生成对应的 TAttributeNode 列表,表示该 table 可以在 SQL 中被使用的字段。 例如:一般 table select column1 from table1 GSP 会在 SQLEnv 中查找 table1 的定义,如果找到(column1,column2,column3), 则 table 会创建三个对应的 TAttributeNode。 用户可以通过TTable.getAttributes()来获取。 如果SQLEnv 中没有查找 table1 的定义,则创建一个 star column TAttributeNode, 形如 table1.* 例如:子查询 select column1 from (select c1,c2 from table1) t1 针对上例中的 t1 子查询, GSP 会创建两个 TAttributeNode,对应 t1.c1, t1.c2 针对其他类型的 table, 也做类似处理。为 SQL 中的每个 table 准备好 TAttributeNode 列表, 在接下来的分析中,SQL 语句中出现的 column 引用都应该能找到对应的来源表和 TAttributeNode 相关的属性TAttributeNode.getName(), 字段名,不带前缀。TAttributeNode.getTable_ref(), 该字段对应的 table,每个在 SQL 语句中出现的 table 都有对应的TTable对象。TAttributeNode.getSqlColumn(), 如果在 SQLEnv 中找到该 table 的定义,这个方法返回数据库中定义的字段、TAttributeNode.getSubLevelResultColumn(), 如果 table 类型为子查询,该方法返回子查询 select list 中的TResultColumn对象,为该字段的数据来源。 或者是 values() 中的 result column。Base lexer of all databases - Core tokenization engine for SQL parsing.Base parser of all databases.TCustomSqlStatement is the root class for all SQL statements.Normalization profiles for SQL hashing.This is the first class people start to use this SQL parser library.Thread-safe parser pool implementation to replace the singleton pattern.Functional interface for parser operations.Pool statistics for monitoring.Represents a source token which is the basic syntactic unit of SQL.List of source token.List of SQL statements which is instance of class that descends fromTCustomSqlStatement.Detailed information about syntax error. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.dlineageClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.dlineage.dataflow.listenerClassDescriptionTCustomSqlStatement is the root class for all SQL statements.This is the first class people start to use this SQL parser library.
-
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.dlineage.dataflow.metadataClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.dlineage.dataflow.metadata.grabitClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.dlineage.dataflow.metadata.sqldepClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.dlineage.dataflow.metadata.sqlenvClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.dlineage.dataflow.metadata.sqlflowClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.dlineage.dataflow.modelClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.Enum for various SQL clause such as where clause, having clause and etc.Type of SQL statement.TCustomSqlStatement is the root class for all SQL statements.Represents a source token which is the basic syntactic unit of SQL. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.dlineage.dataflow.sqlenvClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.dlineage.graphClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.dlineage.metadataClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.dlineage.utilClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.TCustomSqlStatement is the root class for all SQL statements. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.nodesClassDescriptionsubtype of alter column in alter table statement.Teradata datatype attributeDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.
scalar expression: return a single value.Type ofTConstantquery hint typeOracle/DB2 create view, subquery restriction clauseUsed to replace TBaseType.srtNone,srtAsc and srtDescEnum for various SQL clause such as where clause, having clause and etc.Type of SQL statement.A specification that indicates when triggered SQL statements perform in relation to the triggering event.TAttributeNode 类似 column,但含义更广泛。用来表示 SQL 语句中 table 包含的字段(table 或许用 relation 更准确)。 这里的 table 可以是数据库的基本表,也可以是 from clause 中出现的子查询,或者是 CTE。 GSP 会把 SQL 语句中出现的每个 table 都生成对应的 TAttributeNode 列表,表示该 table 可以在 SQL 中被使用的字段。 例如:一般 table select column1 from table1 GSP 会在 SQLEnv 中查找 table1 的定义,如果找到(column1,column2,column3), 则 table 会创建三个对应的 TAttributeNode。 用户可以通过TTable.getAttributes()来获取。 如果SQLEnv 中没有查找 table1 的定义,则创建一个 star column TAttributeNode, 形如 table1.* 例如:子查询 select column1 from (select c1,c2 from table1) t1 针对上例中的 t1 子查询, GSP 会创建两个 TAttributeNode,对应 t1.c1, t1.c2 针对其他类型的 table, 也做类似处理。为 SQL 中的每个 table 准备好 TAttributeNode 列表, 在接下来的分析中,SQL 语句中出现的 column 引用都应该能找到对应的来源表和 TAttributeNode 相关的属性TAttributeNode.getName(), 字段名,不带前缀。TAttributeNode.getTable_ref(), 该字段对应的 table,每个在 SQL 语句中出现的 table 都有对应的TTable对象。TAttributeNode.getSqlColumn(), 如果在 SQLEnv 中找到该 table 的定义,这个方法返回数据库中定义的字段、TAttributeNode.getSubLevelResultColumn(), 如果 table 类型为子查询,该方法返回子查询 select list 中的TResultColumn对象,为该字段的数据来源。 或者是 values() 中的 result column。TCustomSqlStatement is the root class for all SQL statements.This is the first class people start to use this SQL parser library.Represents a source token which is the basic syntactic unit of SQL.List of source token.List of SQL statements which is instance of class that descends fromTCustomSqlStatement. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.nodes.couchbase
-
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.nodes.daxClassDescriptionUsed to replace TBaseType.srtNone,srtAsc and srtDescEnum for various SQL clause such as where clause, having clause and etc.TCustomSqlStatement is the root class for all SQL statements.
-
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.nodes.functionsClassDescriptionEnum for various SQL clause such as where clause, having clause and etc.TCustomSqlStatement is the root class for all SQL statements.
-
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.nodes.hiveClassDescriptionRepresents a source token which is the basic syntactic unit of SQL.
-
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.nodes.mdx
-
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.nodes.mssqlClassDescriptionSQL Server execute as optionType of SQL statement.Represents a source token which is the basic syntactic unit of SQL.
-
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.nodes.mysqlClassDescriptionEnum for various SQL clause such as where clause, having clause and etc.TCustomSqlStatement is the root class for all SQL statements.Represents a source token which is the basic syntactic unit of SQL.
-
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.nodes.oracleClassDescriptionEnum for various SQL clause such as where clause, having clause and etc.TCustomSqlStatement is the root class for all SQL statements.Represents a source token which is the basic syntactic unit of SQL.List of SQL statements which is instance of class that descends from
TCustomSqlStatement. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.nodes.snowflakeClassDescriptionEnum for various SQL clause such as where clause, having clause and etc.TCustomSqlStatement is the root class for all SQL statements.
-
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.nodes.teradataClassDescriptionEnum for various SQL clause such as where clause, having clause and etc.Type of SQL statement.TCustomSqlStatement is the root class for all SQL statements.Represents a source token which is the basic syntactic unit of SQL.
-
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.nodes.verticaClassDescriptionEnum for various SQL clause such as where clause, having clause and etc.TCustomSqlStatement is the root class for all SQL statements.
-
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.parserClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.Deprecated.As of v2.0.3.1, please useTSQLEnvinstead In order to link column to table correctly without connecting to database, we need to provide a class which implements IMetaDatabase to TGSqlParser.This is the interface for handling SQL statements after parsing each SQL statement.use this interface if you like to change token properties generated by lexer before send to parser.
if you change a source token's TSourceToken#tokencode to TBaseType#cmtslashstar TBaseType#cmtdoublehyphen then, this token will be treated as comment
you may also like to change tokencode of a keyword to TBaseType#ident, this will let parser treat this keyword as an identifier.Base lexer of all databases - Core tokenization engine for SQL parsing.Base parser of all databases.TCustomSqlStatement is the root class for all SQL statements.Represents a source token which is the basic syntactic unit of SQL.List of source token.List of SQL statements which is instance of class that descends fromTCustomSqlStatement.Detailed information about syntax error. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.pp.mediator.type
-
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.pp.outputClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.Represents a source token which is the basic syntactic unit of SQL. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.pp.output.htmlClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.Represents a source token which is the basic syntactic unit of SQL. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.pp.printClassDescriptionRepresents a source token which is the basic syntactic unit of SQL.List of source token.
-
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.pp.processorClassDescriptionList of SQL statements which is instance of class that descends from
TCustomSqlStatement. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.pp.processor.type.commClassDescriptionTCustomSqlStatement is the root class for all SQL statements.Represents a source token which is the basic syntactic unit of SQL.List of SQL statements which is instance of class that descends from
TCustomSqlStatement. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.pp.processor.type.selectClassDescriptionTCustomSqlStatement is the root class for all SQL statements.Represents a source token which is the basic syntactic unit of SQL.
-
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.pp.stmtformatterClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.TCustomSqlStatement is the root class for all SQL statements.This is the first class people start to use this SQL parser library.Represents a source token which is the basic syntactic unit of SQL. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.pp.stmtformatter.typeClassDescriptionTCustomSqlStatement is the root class for all SQL statements.List of SQL statements which is instance of class that descends from
TCustomSqlStatement. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.pp.stmtformatter.type.commClassDescriptionTCustomSqlStatement is the root class for all SQL statements.Represents a source token which is the basic syntactic unit of SQL.List of SQL statements which is instance of class that descends from
TCustomSqlStatement. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.pp.utilsClassDescriptionType of source token.Represents a source token which is the basic syntactic unit of SQL.List of source token.
-
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.resolverClassDescriptionTAttributeNode 类似 column,但含义更广泛。用来表示 SQL 语句中 table 包含的字段(table 或许用 relation 更准确)。 这里的 table 可以是数据库的基本表,也可以是 from clause 中出现的子查询,或者是 CTE。 GSP 会把 SQL 语句中出现的每个 table 都生成对应的 TAttributeNode 列表,表示该 table 可以在 SQL 中被使用的字段。 例如:一般 table select column1 from table1 GSP 会在 SQLEnv 中查找 table1 的定义,如果找到(column1,column2,column3), 则 table 会创建三个对应的 TAttributeNode。 用户可以通过
TTable.getAttributes()来获取。 如果SQLEnv 中没有查找 table1 的定义,则创建一个 star column TAttributeNode, 形如 table1.* 例如:子查询 select column1 from (select c1,c2 from table1) t1 针对上例中的 t1 子查询, GSP 会创建两个 TAttributeNode,对应 t1.c1, t1.c2 针对其他类型的 table, 也做类似处理。为 SQL 中的每个 table 准备好 TAttributeNode 列表, 在接下来的分析中,SQL 语句中出现的 column 引用都应该能找到对应的来源表和 TAttributeNode 相关的属性TAttributeNode.getName(), 字段名,不带前缀。TAttributeNode.getTable_ref(), 该字段对应的 table,每个在 SQL 语句中出现的 table 都有对应的TTable对象。TAttributeNode.getSqlColumn(), 如果在 SQLEnv 中找到该 table 的定义,这个方法返回数据库中定义的字段、TAttributeNode.getSubLevelResultColumn(), 如果 table 类型为子查询,该方法返回子查询 select list 中的TResultColumn对象,为该字段的数据来源。 或者是 values() 中的 result column。List of SQL statements which is instance of class that descends fromTCustomSqlStatement. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.resolver2ClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.List of SQL statements which is instance of class that descends fromTCustomSqlStatement. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.resolver2.contextClassDescriptionTCustomSqlStatement is the root class for all SQL statements.List of SQL statements which is instance of class that descends from
TCustomSqlStatement. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.resolver2.formatClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.resolver2.matcherClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.resolver2.metadataClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.List of SQL statements which is instance of class that descends fromTCustomSqlStatement. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.resolver2.modelClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.resolver2.namespaceClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.resolver2.resultClassDescriptionTCustomSqlStatement is the root class for all SQL statements.List of SQL statements which is instance of class that descends from
TCustomSqlStatement. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.resolver2.scopeClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.TCustomSqlStatement is the root class for all SQL statements. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.scriptWriterClassDescription
scalar expression: return a single value.Type of source token.TCustomSqlStatement is the root class for all SQL statements.Represents a source token which is the basic syntactic unit of SQL.List of source token.List of SQL statements which is instance of class that descends fromTCustomSqlStatement. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.sqlcmdsClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.Used by parser internally.Type of SQL statement.TCustomSqlStatement is the root class for all SQL statements.Represents a source token which is the basic syntactic unit of SQL. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.sqlenvClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.sqlenv.calciteClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.sqlenv.catalogClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.sqlenv.parserClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.sqlenv.parser.grabitClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.sqlenv.parser.sqldepClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.sqlenv.parser.sqlflowClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.stmtClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.source of insert valueTAttributeNode 类似 column,但含义更广泛。用来表示 SQL 语句中 table 包含的字段(table 或许用 relation 更准确)。 这里的 table 可以是数据库的基本表,也可以是 from clause 中出现的子查询,或者是 CTE。 GSP 会把 SQL 语句中出现的每个 table 都生成对应的 TAttributeNode 列表,表示该 table 可以在 SQL 中被使用的字段。 例如:一般 table select column1 from table1 GSP 会在 SQLEnv 中查找 table1 的定义,如果找到(column1,column2,column3), 则 table 会创建三个对应的 TAttributeNode。 用户可以通过TTable.getAttributes()来获取。 如果SQLEnv 中没有查找 table1 的定义,则创建一个 star column TAttributeNode, 形如 table1.* 例如:子查询 select column1 from (select c1,c2 from table1) t1 针对上例中的 t1 子查询, GSP 会创建两个 TAttributeNode,对应 t1.c1, t1.c2 针对其他类型的 table, 也做类似处理。为 SQL 中的每个 table 准备好 TAttributeNode 列表, 在接下来的分析中,SQL 语句中出现的 column 引用都应该能找到对应的来源表和 TAttributeNode 相关的属性TAttributeNode.getName(), 字段名,不带前缀。TAttributeNode.getTable_ref(), 该字段对应的 table,每个在 SQL 语句中出现的 table 都有对应的TTable对象。TAttributeNode.getSqlColumn(), 如果在 SQLEnv 中找到该 table 的定义,这个方法返回数据库中定义的字段、TAttributeNode.getSubLevelResultColumn(), 如果 table 类型为子查询,该方法返回子查询 select list 中的TResultColumn对象,为该字段的数据来源。 或者是 values() 中的 result column。TCustomSqlStatement is the root class for all SQL statements.Represents a source token which is the basic syntactic unit of SQL.List of source token.List of SQL statements which is instance of class that descends fromTCustomSqlStatement. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.stmt.bigqueryClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.TCustomSqlStatement is the root class for all SQL statements. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.stmt.couchbaseClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.TCustomSqlStatement is the root class for all SQL statements. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.stmt.databricksClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.TCustomSqlStatement is the root class for all SQL statements. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.stmt.daxClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.TCustomSqlStatement is the root class for all SQL statements. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.stmt.db2ClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.Type of SQL statement.TCustomSqlStatement is the root class for all SQL statements.List of SQL statements which is instance of class that descends fromTCustomSqlStatement. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.stmt.greenplumClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.TCustomSqlStatement is the root class for all SQL statements. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.stmt.hanaClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.TCustomSqlStatement is the root class for all SQL statements. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.stmt.hiveClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.TCustomSqlStatement is the root class for all SQL statements.Represents a source token which is the basic syntactic unit of SQL.List of SQL statements which is instance of class that descends fromTCustomSqlStatement. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.stmt.impalaClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.TCustomSqlStatement is the root class for all SQL statements. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.stmt.informixClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.TCustomSqlStatement is the root class for all SQL statements. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.stmt.mdxClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.TCustomSqlStatement is the root class for all SQL statements.List of SQL statements which is instance of class that descends fromTCustomSqlStatement. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.stmt.mssqlClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.SQL Server execute as optionType of SQL statement.TCustomSqlStatement is the root class for all SQL statements.Represents a source token which is the basic syntactic unit of SQL.List of source token.List of SQL statements which is instance of class that descends fromTCustomSqlStatement. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.stmt.mysqlClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.Type of SQL statement.TCustomSqlStatement is the root class for all SQL statements.List of SQL statements which is instance of class that descends fromTCustomSqlStatement. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.stmt.netezzaClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.TCustomSqlStatement is the root class for all SQL statements. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.stmt.oracleClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.TCustomSqlStatement is the root class for all SQL statements.Represents a source token which is the basic syntactic unit of SQL.List of SQL statements which is instance of class that descends fromTCustomSqlStatement. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.stmt.postgresqlClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.TCustomSqlStatement is the root class for all SQL statements. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.stmt.prestoClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.TCustomSqlStatement is the root class for all SQL statements. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.stmt.redshiftClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.TCustomSqlStatement is the root class for all SQL statements. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.stmt.snowflakeClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.TCustomSqlStatement is the root class for all SQL statements. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.stmt.sparksqlClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.TCustomSqlStatement is the root class for all SQL statements. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.stmt.sybaseClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.TCustomSqlStatement is the root class for all SQL statements. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.stmt.teradataClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.Used by parser internally.TCustomSqlStatement is the root class for all SQL statements. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.stmt.teradata.utilities
-
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.stmt.verticaClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.TCustomSqlStatement is the root class for all SQL statements. -
Classes in gudusoft.gsqlparser used by gudusoft.gsqlparser.utilClassDescriptionDatabase vendors supported:
EDbVendor.dbvmssql,EDbVendor.dbvoracle,EDbVendor.dbvmysql,EDbVendor.dbvdb2,EDbVendor.dbvsybase,EDbVendor.dbvinformix,EDbVendor.dbvpostgresql,EDbVendor.dbvteradata,EDbVendor.dbvmdx,EDbVendor.dbvnetezza,EDbVendor.dbvhive,EDbVendor.dbvgreenplum,EDbVendor.dbvredshift
No specific engine for Microsoft ACCESSEDbVendor.dbvaccess, useEDbVendor.dbvmssqlinstead.Specifies which SQL resolver to use for name resolution during parsing.Deprecated.As of v2.0.3.1, please useTSQLEnvinstead In order to link column to table correctly without connecting to database, we need to provide a class which implements IMetaDatabase to TGSqlParser.TCustomSqlStatement is the root class for all SQL statements.This is the first class people start to use this SQL parser library.
TSQLEnvinstead In order to link column to table correctly without connecting to database, we need to provide a class which implements IMetaDatabase to TGSqlParser.