Minor: Add getter for logical optimizer rules - #12379

Which issue does this PR close?

N/A

Rationale for this change

My team and I have been exploring Datafusion's potential to federate our custom sources performantly. Part of that is tuning optimizers depending on our needs. Noticed that there isn't a convenience method in SessionState yet that returns logical optimizer rules compared to its physical counterpart. Would be great for our POC work to quickly inspect them outside (and/or alongside) debugger or observer.

What changes are included in this PR?

Adds a getter method optimizers() in SessionState in parity to the physical_optimizers() counterpart.

Are these changes tested?

Yes, ran new and existing tests. Also manually tested from our existing POC code.

Are there any user-facing changes?

Examples:

let state = SessionStateBuilder::new()
    .with_optimizer_rules(vec![
        Arc::new(UnwrapCastInComparison::new()),
        Arc::new(SimplifyExpressions::new()),
        Arc::new(OptimizeProjections::new()),
        Arc::new(PushDownFilter::new()),
    ])
    .build();

let optimizer_rules = state.optimizers();
for rule in optimizer_rules {
    println!("Optimizer: {}", rule.name());
}