ScopeBuilder (General SQL Parser Java Library Core 4.1.0.5 API)

Object
- gudusoft.gsqlparser.nodes.TParseTreeVisitor
- - gudusoft.gsqlparser.resolver2.ScopeBuilder

```
public class ScopeBuilder
extends TParseTreeVisitor
```
Builds a complete scope tree using the Visitor pattern.
This class traverses the AST and creates a properly nested scope tree that reflects the SQL structure. All SELECT statements (including subqueries and CTEs) get their own SelectScope with correct parent-child relationships.
Key features:
- Handles nested subqueries with correct parent scope
- Handles CTEs with forward reference support
- Collects all column references with their scope mappings
- Supports complex SQL patterns (CTE + subquery combinations)
Usage:
```
 ScopeBuilder builder = new ScopeBuilder(context, nameMatcher);
 ScopeBuildResult result = builder.build(statements);
 
```

Constructor Summary

Constructors
Constructor and Description
`ScopeBuilder(gudusoft.gsqlparser.compiler.TContext globalContext)`
`ScopeBuilder(gudusoft.gsqlparser.compiler.TContext globalContext, INameMatcher nameMatcher)`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`ScopeBuildResult`	`build(TStatementList statements)` Build scope tree for the given SQL statements.
`Map<TDeleteSqlStatement,DeleteScope>`	`getDeleteScopeMap()`
`GlobalScope`	`getGlobalScope()`
`int`	`getGuessColumnStrategy()` Get the strategy for handling ambiguous columns.
`Set<TObjectName>`	`getInsertAllTargetColumns()` Get the set of INSERT ALL target columns (from TInsertIntoValue columnList).
`Map<TObjectName,TTable>`	`getMergeInsertValuesColumns()` Get the map of MERGE INSERT VALUES columns to their USING (source) table.
`INameMatcher`	`getNameMatcher()`
`Set<TObjectName>`	`getSetClauseTargetColumns()` Get the set of SET clause target columns (UPDATE SET left-side columns).
`TSQLEnv`	`getSqlEnv()` Get the TSQLEnv used for table metadata lookup.
`Map<TUpdateSqlStatement,UpdateScope>`	`getUpdateScopeMap()`
`Map<TObjectName,TTable>`	`getUsingColumnToRightTable()` Get the mapping of USING columns to their right-side tables.
`Set<TTable>`	`getVirtualTriggerTables()` Get the set of virtual trigger tables (deleted/inserted in SQL Server triggers).
`void`	`postVisit(TBlockSqlNode node)`
`void`	`postVisit(TBlockSqlStatement stmt)`
`void`	`postVisit(TCreateFunctionStmt stmt)`
`void`	`postVisit(TCreateProcedureStmt stmt)`
`void`	`postVisit(TCreateTableSqlStatement stmt)`
`void`	`postVisit(TCreateTriggerStmt stmt)`
`void`	`postVisit(TCTE cte)`
`void`	`postVisit(TCTEList cteList)`
`void`	`postVisit(TDb2CreateFunction stmt)`
`void`	`postVisit(TDeleteSqlStatement stmt)`
`void`	`postVisit(TExecImmeStmt stmt)`
`void`	`postVisit(TExpression expression)`
`void`	`postVisit(TFromClause fromClause)`
`void`	`postVisit(TInsertSqlStatement stmt)`
`void`	`postVisit(TJoinItem joinItem)`
`void`	`postVisit(TLoopStmt stmt)`
`void`	`postVisit(TMergeSqlStatement stmt)`
`void`	`postVisit(TMySQLCreateProcedure stmt)`
`void`	`postVisit(TPlsqlCreateFunction stmt)`
`void`	`postVisit(TPlsqlCreatePackage pkg)`
`void`	`postVisit(TPlsqlCreateProcedure stmt)`
`void`	`postVisit(TResultColumn resultColumn)`
`void`	`postVisit(TSelectSqlStatement stmt)`
`void`	`postVisit(TTable table)`
`void`	`postVisit(TUpdateSqlStatement stmt)`
`void`	`preVisit(TAlterTableStatement stmt)`
`void`	`preVisit(TBlockSqlNode node)`
`void`	`preVisit(TBlockSqlStatement stmt)`
`void`	`preVisit(TCommonBlock stmt)`
`void`	`preVisit(TConstraint constraint)`
`void`	`preVisit(TCreateFileFormatStmt stmt)`
`void`	`preVisit(TCreateFunctionStmt stmt)`
`void`	`preVisit(TCreateIndexSqlStatement stmt)`
`void`	`preVisit(TCreatePipeStmt stmt)`
`void`	`preVisit(TCreateProcedureStmt stmt)`
`void`	`preVisit(TCreateStageStmt stmt)`
`void`	`preVisit(TCreateTableSqlStatement stmt)`
`void`	`preVisit(TCreateTriggerStmt stmt)`
`void`	`preVisit(TCTE cte)`
`void`	`preVisit(TCTEList cteList)`
`void`	`preVisit(TCursorDeclStmt cursorDecl)`
`void`	`preVisit(TDb2CreateFunction stmt)`
`void`	`preVisit(TDb2DeclareCursorStatement stmt)`
`void`	`preVisit(TDb2ReturnStmt stmt)`
`void`	`preVisit(TDb2SqlVariableDeclaration stmt)`
`void`	`preVisit(TDeleteSqlStatement stmt)`
`void`	`preVisit(TDropIndexSqlStatement stmt)`
`void`	`preVisit(TExecImmeStmt stmt)`
`void`	`preVisit(TExpression expression)`
`void`	`preVisit(TForStmt stmt)`
`void`	`preVisit(TFromClause fromClause)`
`void`	`preVisit(TFunctionCall functionCall)`
`void`	`preVisit(TInsertIntoValue insertIntoValue)`
`void`	`preVisit(TInsertSqlStatement stmt)`
`void`	`preVisit(TJoinExpr joinExpr)`
`void`	`preVisit(TJoinItem joinItem)`
`void`	`preVisit(TLoopStmt stmt)`
`void`	`preVisit(TMergeInsertClause insertClause)`
`void`	`preVisit(TMergeSqlStatement stmt)`
`void`	`preVisit(TMergeUpdateClause updateClause)`
`void`	`preVisit(TMssqlCreateTriggerUpdateColumn node)` Handle SQL Server trigger UPDATE(column) function.
`void`	`preVisit(TMssqlDeclare stmt)`
`void`	`preVisit(TMssqlReturn stmt)`
`void`	`preVisit(TMySQLCreateProcedure stmt)`
`void`	`preVisit(TObjectName objectName)`
`void`	`preVisit(TOpenforStmt openFor)`
`void`	`preVisit(TOutputClause outputClause)`
`void`	`preVisit(TPlsqlCreateFunction stmt)`
`void`	`preVisit(TPlsqlCreatePackage pkg)`
`void`	`preVisit(TPlsqlCreateProcedure stmt)`
`void`	`preVisit(TPlsqlCreateTrigger stmt)`
`void`	`preVisit(TResultColumn resultColumn)`
`void`	`preVisit(TSelectSqlStatement stmt)`
`void`	`preVisit(TTable table)`
`void`	`preVisit(TUpdateSqlStatement stmt)`
`void`	`preVisit(TVarDeclStmt stmt)`
`void`	`setGuessColumnStrategy(int strategy)` Set the strategy for handling ambiguous columns.
`void`	`setSqlEnv(TSQLEnv sqlEnv)` Set the TSQLEnv for table metadata lookup.

Methods inherited from class gudusoft.gsqlparser.nodes.TParseTreeVisitor
postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, postVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit, preVisit

Methods inherited from class Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Constructor Detail
  - ScopeBuilder
```
public ScopeBuilder(gudusoft.gsqlparser.compiler.TContext globalContext,
                    INameMatcher nameMatcher)
```
  - ScopeBuilder
```
public ScopeBuilder(gudusoft.gsqlparser.compiler.TContext globalContext)
```
- Method Detail
  - setSqlEnv
```
public void setSqlEnv(TSQLEnv sqlEnv)
```
    Set the TSQLEnv for table metadata lookup. This can be used to override the TSQLEnv from globalContext.
    
    Parameters:
    
    sqlEnv - the SQL environment containing table metadata
  - getSqlEnv
```
public TSQLEnv getSqlEnv()
```
    Get the TSQLEnv used for table metadata lookup.
    
    Returns:
    
    the SQL environment, or null if not set
  - setGuessColumnStrategy
```
public void setGuessColumnStrategy(int strategy)
```
    Set the strategy for handling ambiguous columns. This value will be passed to namespaces for config-based isolation.
    
    Parameters:
    
    strategy - One of TBaseType.GUESS_COLUMN_STRATEGY_* constants, or -1 to use global default
  - getGuessColumnStrategy
```
public int getGuessColumnStrategy()
```
    Get the strategy for handling ambiguous columns.
    
    Returns:
    
    The strategy constant, or -1 if not set (use global default)
  - build
```
public ScopeBuildResult build(TStatementList statements)
```
    Build scope tree for the given SQL statements.
    
    Parameters:
    
    statements - SQL statements to process
    
    Returns:
    
    Build result containing scope tree and column mappings
  - preVisit
```
public void preVisit(TCreateTableSqlStatement stmt)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - postVisit
```
public void postVisit(TCreateTableSqlStatement stmt)
```
    Overrides:
    
    postVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TConstraint constraint)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TSelectSqlStatement stmt)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - postVisit
```
public void postVisit(TSelectSqlStatement stmt)
```
    Overrides:
    
    postVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TUpdateSqlStatement stmt)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - postVisit
```
public void postVisit(TUpdateSqlStatement stmt)
```
    Overrides:
    
    postVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TInsertSqlStatement stmt)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - postVisit
```
public void postVisit(TInsertSqlStatement stmt)
```
    Overrides:
    
    postVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TInsertIntoValue insertIntoValue)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TDeleteSqlStatement stmt)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - postVisit
```
public void postVisit(TDeleteSqlStatement stmt)
```
    Overrides:
    
    postVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TOutputClause outputClause)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TCreateTriggerStmt stmt)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - postVisit
```
public void postVisit(TCreateTriggerStmt stmt)
```
    Overrides:
    
    postVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TPlsqlCreateTrigger stmt)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TCreateIndexSqlStatement stmt)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TDropIndexSqlStatement stmt)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TExecImmeStmt stmt)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - postVisit
```
public void postVisit(TExecImmeStmt stmt)
```
    Overrides:
    
    postVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TLoopStmt stmt)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - postVisit
```
public void postVisit(TLoopStmt stmt)
```
    Overrides:
    
    postVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TCreateFileFormatStmt stmt)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TCreateStageStmt stmt)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TCreatePipeStmt stmt)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TAlterTableStatement stmt)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TMssqlCreateTriggerUpdateColumn node)
```
    Handle SQL Server trigger UPDATE(column) function. The column inside UPDATE() should be resolved to the trigger target table. Example: IF UPDATE(Zip) - Zip column belongs to the trigger's ON table.
    
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TCommonBlock stmt)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TPlsqlCreatePackage pkg)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - postVisit
```
public void postVisit(TPlsqlCreatePackage pkg)
```
    Overrides:
    
    postVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TBlockSqlNode node)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - postVisit
```
public void postVisit(TBlockSqlNode node)
```
    Overrides:
    
    postVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TVarDeclStmt stmt)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TCursorDeclStmt cursorDecl)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TOpenforStmt openFor)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TMssqlDeclare stmt)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TDb2SqlVariableDeclaration stmt)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TDb2DeclareCursorStatement stmt)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TDb2CreateFunction stmt)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - postVisit
```
public void postVisit(TDb2CreateFunction stmt)
```
    Overrides:
    
    postVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TCreateFunctionStmt stmt)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - postVisit
```
public void postVisit(TCreateFunctionStmt stmt)
```
    Overrides:
    
    postVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TDb2ReturnStmt stmt)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TMssqlReturn stmt)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TPlsqlCreateProcedure stmt)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - postVisit
```
public void postVisit(TPlsqlCreateProcedure stmt)
```
    Overrides:
    
    postVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TPlsqlCreateFunction stmt)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - postVisit
```
public void postVisit(TPlsqlCreateFunction stmt)
```
    Overrides:
    
    postVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TCreateProcedureStmt stmt)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - postVisit
```
public void postVisit(TCreateProcedureStmt stmt)
```
    Overrides:
    
    postVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TMySQLCreateProcedure stmt)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - postVisit
```
public void postVisit(TMySQLCreateProcedure stmt)
```
    Overrides:
    
    postVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TBlockSqlStatement stmt)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - postVisit
```
public void postVisit(TBlockSqlStatement stmt)
```
    Overrides:
    
    postVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TForStmt stmt)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TMergeSqlStatement stmt)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - postVisit
```
public void postVisit(TMergeSqlStatement stmt)
```
    Overrides:
    
    postVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TMergeUpdateClause updateClause)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TMergeInsertClause insertClause)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TCTEList cteList)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - postVisit
```
public void postVisit(TCTEList cteList)
```
    Overrides:
    
    postVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TCTE cte)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - postVisit
```
public void postVisit(TCTE cte)
```
    Overrides:
    
    postVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TFromClause fromClause)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - postVisit
```
public void postVisit(TFromClause fromClause)
```
    Overrides:
    
    postVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TTable table)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - postVisit
```
public void postVisit(TTable table)
```
    Overrides:
    
    postVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TJoinExpr joinExpr)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TJoinItem joinItem)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - postVisit
```
public void postVisit(TJoinItem joinItem)
```
    Overrides:
    
    postVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TExpression expression)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - postVisit
```
public void postVisit(TExpression expression)
```
    Overrides:
    
    postVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TFunctionCall functionCall)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TResultColumn resultColumn)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - postVisit
```
public void postVisit(TResultColumn resultColumn)
```
    Overrides:
    
    postVisit in class TParseTreeVisitor
  - preVisit
```
public void preVisit(TObjectName objectName)
```
    Overrides:
    
    preVisit in class TParseTreeVisitor
  - getGlobalScope
```
public GlobalScope getGlobalScope()
```
  - getNameMatcher
```
public INameMatcher getNameMatcher()
```
  - getUpdateScopeMap
```
public Map<TUpdateSqlStatement,UpdateScope> getUpdateScopeMap()
```
  - getDeleteScopeMap
```
public Map<TDeleteSqlStatement,DeleteScope> getDeleteScopeMap()
```
  - getUsingColumnToRightTable
```
public Map<TObjectName,TTable> getUsingColumnToRightTable()
```
    Get the mapping of USING columns to their right-side tables. In JOIN...USING syntax, USING columns should preferentially resolve to the right-side (physical) table for TGetTableColumn compatibility.
    
    Returns:
    
    Map of USING column TObjectName -> right-side TTable
  - getVirtualTriggerTables
```
public Set<TTable> getVirtualTriggerTables()
```
    Get the set of virtual trigger tables (deleted/inserted in SQL Server triggers). These tables should be excluded from table output since their columns are resolved to the trigger's target table.
    
    Returns:
    
    Set of TTable objects that are virtual trigger tables
  - getSetClauseTargetColumns
```
public Set<TObjectName> getSetClauseTargetColumns()
```
    Get the set of SET clause target columns (UPDATE SET left-side columns). These columns already have sourceTable correctly set to the UPDATE target table and should NOT be re-resolved through star column push-down.
    
    Returns:
    
    Set of TObjectName nodes that are SET clause target columns
  - getInsertAllTargetColumns
```
public Set<TObjectName> getInsertAllTargetColumns()
```
    Get the set of INSERT ALL target columns (from TInsertIntoValue columnList). These columns already have sourceTable correctly set to the INSERT target table and should NOT be re-resolved against the subquery scope.
    
    Returns:
    
    Set of TObjectName nodes that are INSERT ALL target columns
  - getMergeInsertValuesColumns
```
public Map<TObjectName,TTable> getMergeInsertValuesColumns()
```
    Get the map of MERGE INSERT VALUES columns to their USING (source) table. After name resolution, the resolver should restore sourceTable for these columns to ensure they correctly link to the USING table per MERGE semantics.
    
    Returns:
    
    Map of TObjectName to their USING table

Class ScopeBuilder

Constructor Summary

Method Summary

Methods inherited from class gudusoft.gsqlparser.nodes.TParseTreeVisitor

Methods inherited from class Object

Constructor Detail

ScopeBuilder

ScopeBuilder

Method Detail

setSqlEnv

getSqlEnv

setGuessColumnStrategy

getGuessColumnStrategy

build

preVisit

postVisit

preVisit

preVisit

postVisit

preVisit

postVisit

preVisit

postVisit

preVisit

preVisit

postVisit

preVisit

preVisit

postVisit

preVisit

preVisit

preVisit

preVisit

postVisit

preVisit

postVisit

preVisit

preVisit

preVisit

preVisit

preVisit

preVisit

preVisit

postVisit

preVisit

postVisit

preVisit

preVisit

preVisit

preVisit

preVisit

preVisit

preVisit

postVisit

preVisit

postVisit

preVisit

preVisit

preVisit

postVisit

preVisit

postVisit

preVisit

postVisit

preVisit

postVisit

preVisit

postVisit

preVisit

preVisit

postVisit

preVisit

preVisit

preVisit

postVisit

preVisit

postVisit

preVisit

postVisit

preVisit