CTENamespace (General SQL Parser Java Library Core 4.1.0.5 API)

Object
- gudusoft.gsqlparser.resolver2.namespace.AbstractNamespace
- - gudusoft.gsqlparser.resolver2.namespace.CTENamespace

All Implemented Interfaces:

INamespace
```
public class CTENamespace
extends AbstractNamespace
```
Namespace representing a Common Table Expression (CTE). Similar to SubqueryNamespace but handles CTE-specific features: - Explicit column list: WITH cte(c1, c2) AS (SELECT ...) - Recursive CTEs - Multiple references within same query - UNION subqueries: columns are pushed through to all UNION branches Example: WITH my_cte(id, name) AS ( SELECT user_id, user_name FROM users ) SELECT id, name FROM my_cte;

Field Summary
- Fields inherited from class gudusoft.gsqlparser.resolver2.namespace.AbstractNamespace
  columnSources, columnSourcesWithRefs, guessColumnStrategy, nameMatcher, node, referenceTraceabilityEnabled, validated

Constructor Summary

Constructors
Constructor and Description
`CTENamespace(TCTE cte, String cteName, TSelectSqlStatement selectStatement)`
`CTENamespace(TCTE cte, String cteName, TSelectSqlStatement selectStatement, INameMatcher nameMatcher)`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`boolean`	`addInferredColumn(String columnName, double confidence, String evidence)` Add an inferred column to this namespace.
`protected void`	`doValidate()` Subclasses override this to perform actual validation logic.
`List<TTable>`	`getAllFinalTables()` Get all final physical tables this namespace depends on.
`TCTE`	`getCTE()`
`String`	`getDisplayName()` Get a display name for this namespace (for debugging/error messages)
`List<String>`	`getExplicitColumns()`
`TTable`	`getFinalTable()` Get the final physical table this namespace represents.
`Set<String>`	`getInferredColumns()` Get all columns that were inferred (not from SELECT list directly).
`TTable`	`getReferencingTable()` Get the TTable that references this CTE in a FROM clause.
`TSelectSqlStatement`	`getSelectStatement()` Get the underlying SELECT statement for this namespace.
`TTable`	`getSourceTable()` Get the TTable that this namespace is associated with.
`UnionNamespace`	`getUnionNamespace()` Get the UnionNamespace if this CTE's subquery is a UNION.
`ColumnLevel`	`hasColumn(String columnName)` Check if a column exists in this namespace.
`boolean`	`hasStarColumn()` Check if this namespace contains a star column (SELECT *).
`boolean`	`isRecursive()`
`ColumnSource`	`resolveColumn(String columnName)` Resolve a column name to its source.
`void`	`setReferencingTable(TTable table)` Set the TTable that references this CTE in a FROM clause.
`boolean`	`supportsDynamicInference()` Check if this namespace supports dynamic column inference.
`String`	`toString()`

Methods inherited from class gudusoft.gsqlparser.resolver2.namespace.AbstractNamespace
addColumnSource, addColumnSource, enableReferenceTraceability, ensureValidated, getAllColumnSources, getAllUniqueColumns, getColumnReferences, getColumnSourceWithReferences, getGuessColumnStrategy, getNameMatcher, getNode, isReferenceTraceabilityEnabled, isValidated, setGuessColumnStrategy, validate

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

Methods inherited from interface gudusoft.gsqlparser.resolver2.namespace.INamespace
getStarColumn, resolveColumnPath

- Constructor Detail
  - CTENamespace
```
public CTENamespace(TCTE cte,
                    String cteName,
                    TSelectSqlStatement selectStatement,
                    INameMatcher nameMatcher)
```
  - CTENamespace
```
public CTENamespace(TCTE cte,
                    String cteName,
                    TSelectSqlStatement selectStatement)
```
- Method Detail
  - getDisplayName
```
public String getDisplayName()
```
    Description copied from interface: INamespace
    
    Get a display name for this namespace (for debugging/error messages)
  - getReferencingTable
```
public TTable getReferencingTable()
```
    Get the TTable that references this CTE in a FROM clause.
  - getSourceTable
```
public TTable getSourceTable()
```
    Get the TTable that this namespace is associated with. Used for legacy sync to set TObjectName.sourceTable. For TableNamespace: returns the table itself For SubqueryNamespace: returns the TTable wrapping the subquery For CTENamespace: returns the CTE referencing table For others: returns null For CTENamespace, returns the TTable that references this CTE in the query. This is the immediate source table for columns resolved through this CTE.
    
    Returns:
    
    The source TTable, or null if not applicable
  - setReferencingTable
```
public void setReferencingTable(TTable table)
```
    Set the TTable that references this CTE in a FROM clause. Called by ScopeBuilder when a CTE is referenced.
  - getFinalTable
```
public TTable getFinalTable()
```
    Description copied from interface: INamespace
    
    Get the final physical table this namespace represents. For tables: returns the table itself For subqueries/CTEs: recursively traces back to physical table(s)
    
    Returns:
    
    Physical table, or null if not determinable
  - getAllFinalTables
```
public List<TTable> getAllFinalTables()
```
    Description copied from interface: INamespace
    
    Get all final physical tables this namespace depends on. For simple table namespace: returns single table For subquery/CTE: returns all tables in the query tree
    
    Specified by:
    
    getAllFinalTables in interface INamespace
    
    Overrides:
    
    getAllFinalTables in class AbstractNamespace
    
    Returns:
    
    List of all physical tables
  - doValidate
```
protected void doValidate()
```
    Description copied from class: AbstractNamespace
    
    Subclasses override this to perform actual validation logic.
    
    Specified by:
    
    doValidate in class AbstractNamespace
  - getCTE
```
public TCTE getCTE()
```
  - getSelectStatement
```
public TSelectSqlStatement getSelectStatement()
```
    Description copied from interface: INamespace
    
    Get the underlying SELECT statement for this namespace. For CTENamespace: returns the CTE's subquery For SubqueryNamespace: returns the subquery For TableNamespace: returns null
    
    Returns:
    
    the SELECT statement, or null if not applicable
  - hasStarColumn
```
public boolean hasStarColumn()
```
    Description copied from interface: INamespace
    
    Check if this namespace contains a star column (SELECT *). Used to identify namespaces that may need star column inference.
    
    Returns:
    
    true if the namespace has SELECT *, false otherwise
  - supportsDynamicInference
```
public boolean supportsDynamicInference()
```
    Description copied from interface: INamespace
    
    Check if this namespace supports dynamic column inference. DynamicStarSource and similar namespaces return true.
    
    Returns:
    
    true if this namespace can have columns added dynamically
  - addInferredColumn
```
public boolean addInferredColumn(String columnName,
                                 double confidence,
                                 String evidence)
```
    Description copied from interface: INamespace
    
    Add an inferred column to this namespace. Used by star column push-down to add columns discovered from outer queries.
    
    Parameters:
    
    columnName - the column name to add
    
    confidence - the confidence score (0.0 to 1.0)
    
    evidence - description of why this column was inferred
    
    Returns:
    
    true if the column was added, false if already exists
  - getInferredColumns
```
public Set<String> getInferredColumns()
```
    Description copied from interface: INamespace
    
    Get all columns that were inferred (not from SELECT list directly). These are columns discovered through star column push-down.
    
    Returns:
    
    set of inferred column names, empty if none
  - hasColumn
```
public ColumnLevel hasColumn(String columnName)
```
    Description copied from interface: INamespace
    
    Check if a column exists in this namespace. Returns a three-level answer: EXISTS, MAYBE, NOT_EXISTS
    
    Specified by:
    
    hasColumn in interface INamespace
    
    Overrides:
    
    hasColumn in class AbstractNamespace
    
    Parameters:
    
    columnName - Column name to check
    
    Returns:
    
    Column existence level
  - resolveColumn
```
public ColumnSource resolveColumn(String columnName)
```
    Description copied from interface: INamespace
    
    Resolve a column name to its source.
    
    Specified by:
    
    resolveColumn in interface INamespace
    
    Overrides:
    
    resolveColumn in class AbstractNamespace
    
    Parameters:
    
    columnName - Column name to resolve
    
    Returns:
    
    ColumnSource if found, null otherwise
  - getUnionNamespace
```
public UnionNamespace getUnionNamespace()
```
    Get the UnionNamespace if this CTE's subquery is a UNION.
  - getExplicitColumns
```
public List<String> getExplicitColumns()
```
  - isRecursive
```
public boolean isRecursive()
```
  - toString
```
public String toString()
```
    Overrides:
    
    toString in class AbstractNamespace

Class CTENamespace

Field Summary

Fields inherited from class gudusoft.gsqlparser.resolver2.namespace.AbstractNamespace

Constructor Summary

Method Summary

Methods inherited from class gudusoft.gsqlparser.resolver2.namespace.AbstractNamespace

Methods inherited from class Object

Methods inherited from interface gudusoft.gsqlparser.resolver2.namespace.INamespace

Constructor Detail

CTENamespace

CTENamespace

Method Detail

getDisplayName

getReferencingTable

getSourceTable

setReferencingTable

getFinalTable

getAllFinalTables

doValidate

getCTE

getSelectStatement

hasStarColumn

supportsDynamicInference

addInferredColumn

getInferredColumns

hasColumn

resolveColumn

getUnionNamespace

getExplicitColumns

isRecursive

toString