Optgen is a small setup for generating analyzer code from templates derived from cockroachdb's optgen.
Usage:
$ go install ./optgen/cmd/optgen
$ go generate ./...The bulk of analyzer logic is normalization rules, join ordering transforms, and execution specific code. Analyzer expressions are mostly boilerplate, and specific normalization rules and join transforms only need types, fields, and literal values to manipulate logical query plans.
Leaning into templates and this harness can reduce code footprint and standardize optimizer nodes when the opportunities arise.
If we end up using more of cockroach DB's optimizer, they codegen their expressions, normalization rules, exploration rules, and execution code stem from this general setup.
AggGen: sql package unary aggregate expression definitions.
FrameGen: plan package nodes that implement sql.WindowFrame.
FrameFactoryGen: parse package function NewFrame
that coverts ast.Frameinto a sql.WindowFrame definitions
from plan.
FramerGen: sql package sql.WindowFramer implementations
and NewFramer function that converts a plan.WindowFrame
into sql.WindowFramer implementations.