Module optimizer 

Query optimization passes.

Inspired by Python sqlglot’s optimizer module. Currently implements:

• Constant folding (e.g., 1 + 2 → 3)
• Boolean simplification (e.g., TRUE AND x → x)
• Dead predicate elimination (e.g., WHERE TRUE)
• Subquery unnesting / decorrelation (EXISTS, IN → JOINs)

Future optimizations:

• Predicate pushdown
• Join reordering
• Column pruning

Modules

unnest_subqueries

Functions

optimize

Optimize a SQL statement by applying transformation passes.