Is your feature request related to a problem or challenge?
It would be nice to be able to remove logical optimizer rules (by name) temporarily from a SessionContext, instead of having to create a new one. There is already a method to add new rules (add_optimizer_rule).
Describe the solution you'd like
I would be happy to add this, it would only take a remove_optimizer_rule in the SessionContext and another remove_optimizer_rule in the SessionState to mutate the list.
Describe alternatives you've considered
No response
Additional context
No response