Create integration tests for optimizer crate

[andygrove]

Is your feature request related to a problem or challenge? Please describe what you are trying to do. I would like integration tests in the optimizer crate where we can easily add SQL and expected output plans so we can catch regressions as new rules are added

Describe the solution you'd like I will file a PR with a proposal

Describe alternatives you've considered None

Additional context None