Support datatype cast for insert api same as insert into sql #15015

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:

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response