Implement `Debug` for `SessionStateBuilder

[alamb]

Is your feature request related to a problem or challenge?

Part of #12550

While working on https://github.com/datafusion-contrib/datafusion-dft I found it would be nice to have Debug for SessionStateBuilder so I could debug the actual state

Describe the solution you'd like

I would like SessionStateBuilder to implement Debug

Describe alternatives you've considered

I started working on this and it turns out many of the sub structs (like Analyzer and Optimizer don't implement debug). This I recommend making a series of PRs to slowly add debug to the necessary structures so we can enable it for evertthing

Additional context

No response

[alamb]

A good way to find out what is left would be to put #[derive(Debug)] on SessionStateBuilder and then work down the errors

[alamb]

I think this is also a good first issue as it has a well defined scope and it is largely mechanical (doesn't require deep codebase knowledge)

Note I made a first step here: #12556

[alamb]

Here is another PR: #12557

[OussamaSaoudi]

take

[AnthonyZhOon]

Added a PR: #12624

[AnthonyZhOon]

I started on CatalogProvider but ran into TableProvider requiring Debug, waiting on #12557 which covers this to merge.