Skip to main content

Module isolate_table_selects

Module isolate_table_selects 

Source
Expand description

Isolation of table references into subqueries Isolate Table Selects Optimization Pass

This module wraps plain table references in subqueries (SELECT * FROM table) when multiple tables are present in a scope. This normalization is needed for other optimizations (like merge_subqueries) to work correctly, since they expect each source in a multi-table query to be a subquery rather than a bare table reference.

Ported from sqlglot’s optimizer/isolate_table_selects.py

Enums§

IsolateTableSelectsError
Error type for the isolate_table_selects pass

Functions§

isolate_table_selects
Wrap plain table references in subqueries when multiple sources are present.