Create integration tests for optimizer crate

**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

Start by reviewing the optimizer crate's existing test layout and how SQL and expected output plans are currently represented. The work is done when the integration-test structure supports adding optimizer cases and catches regressions as new rules are added.

Written by the indexing model from the issue text.