improve insert statement generation with insert column list.

[kccarter76]

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