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