egg

This article explains how to build a SQL optimizer using the Egg framework in Rust, covering techniques like constant folding, predicate pushdown, and join reordering with rule- and cost-based optimization, using under a thousand lines of code.