Is your feature request related to a problem or challenge?

Currently there isn't a way that I can see to unset/reset to default a config option that has a type of Option<xyz> that has a default of None. It would be useful to have this ability.

postgresql seems to support multiple ways to do this:

RESET configuration_parameter;
SET configuration_parameter TO DEFAULT;

https://www.postgresql.org/docs/current/sql-reset.html
https://www.postgresql.org/docs/current/sql-set.html

Duckdb uses reset
MySQL uses reset

I would suggest that DataFusion should add support for a RESET sql command.

Describe the solution you'd like

RESET <config>; would work to reset the config back to whatever it's default is.

Describe alternatives you've considered

Alternative is to not support this functionality.

Additional context

No response