Support string to numeric coercion

[zyuiop]

Is your feature request related to a problem or challenge?

Queries such as select 1 + "1"; should be supported by datafusion, but currently are not supported (expressions have incompatible types).

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response

[comphead]

Thanks @zyuiop I totally agree with your query with small modifications though

> select 1 + '1';
Error during planning: Cannot coerce arithmetic expression Int64 + Utf8 to valid types

However pgsql

select 1 + '1'

 ?column? 
----------
        2
(1 row)