Support datatype cast for insert api same as insert into sql

[zhuqi-lucas]

Is your feature request related to a problem or challenge?

Now insert into sql we will automatically case the datatype to consistent with the table datatype, we'd better to support datatype cast for insert api also. So we will make the insert into behaviour consistent.

Details code for sql way for insert into:

The code here:

datafusion/datafusion/sql/src/statement.rs

Line 1958 in 2011f52

.cast_to(target_field.data_type(), source.schema())?

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response

[zhuqi-lucas]

take

[alamb]

makes sense to me -- thank you @zhuqi-lucas

[zhuqi-lucas]

Thank you @alamb for confirming, submitted the PR to fix it.
#15091