Is your feature request related to a problem? Please describe.
Currently, inserting record is dependent on matching the column order in the schema. If the code model differs from the schema model in column ordering. there would be a problem.
Describe the solution you'd like
the insert into statement would use to the INSERT INTO [SCHEMA].[TABLE] ([column1], [column3], [column2]) instead of just INSERT INTO [SCHEMA].[TABLE] .
note:
prepare the insert and update queries with the ability to track index position in table type and in memory tables
Is your feature request related to a problem? Please describe.
Currently, inserting record is dependent on matching the column order in the schema. If the code model differs from the schema model in column ordering. there would be a problem.
Describe the solution you'd like
the insert into statement would use to the INSERT INTO [SCHEMA].[TABLE] ([column1], [column3], [column2]) instead of just INSERT INTO [SCHEMA].[TABLE] .
note:
prepare the insert and update queries with the ability to track index position in table type and in memory tables