[EPIC] Optimize the `CONCAT` expression in logical plan

[HaoYang670]

Is your feature request related to a problem or challenge? Please describe what you are trying to do.
There are some ideas I think we can have a try, and all of them are related to scalar:

• Concatenate contiguous literal arguments of CONCAT during the expression simplification. #3683
• Concatenate contiguous literal arguments of concat_ws when doing the expression simplification #3856
• Simplify CONCAT_WS(NULL, ..) to NULL #3607
• Replace concat_ws with concat when the delimiter is empty string #3857
• Simplify col1 || 'a' || 'b' || col2 to col1 || 'ab' || col2 #17158

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

[alamb]

I filed the last remaining issue as

• Simplify col1 || 'a' || 'b' || col2 to col1 || 'ab' || col2 #17158

I don't think the epic needs to be open anymore -- we can just track the work in the individual ticket