Support datatype cast for insert api same as insert into sql #15015
Description
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
Describe the solution you'd like
No response
Describe alternatives you've considered
No response
Additional context
No response