Make datafusion support materializing option for CTE

### Is your feature request related to a problem or challenge?

For example postgresql supports the option for it:

https://www.postgresql.org/docs/current/queries-with.html#QUERIES-WITH-CTE-MATERIALIZATION

Make datafusion support materializing option for CTE, it will be very useful and helpful.

### Describe the solution you'd like

_No response_

### Describe alternatives you've considered

_No response_

### Additional context

_No response_

Start by reading the PostgreSQL CTE materialization documentation linked in the issue and then trace how DataFusion currently plans and executes CTEs. Define the supported materializing option and its expected behavior before identifying the parser, planner, and test entry points involved. Done means DataFusion accepts the option and verifies its materialization behavior with tests.

Written by the indexing model from the issue text.