Module correlated_subquery_analyzer 

Correlated Subquery Analysis

This module analyzes SELECT statements to detect and classify subqueries, particularly correlated subqueries that reference columns from outer queries.

Purpose

Before we can transform correlated subqueries, we need to understand:

• Where subqueries appear in the query
• Which subqueries are correlated (reference outer query)
• What type of correlation exists (scalar, EXISTS, IN, etc.)
• Which columns are referenced from outer scope

This analyzer provides visibility into these patterns, which will inform future transformation strategies.

Structs

CorrelatedSubqueryAnalyzer

Analyzer for detecting and classifying correlated subqueries

CorrelationAnalysis

Analysis results for a query

SubqueryInfo

Information about a detected subquery

Enums

SubqueryLocation

Location where a subquery appears

SubqueryType

Type of subquery based on its usage