Feature Request: Support updating only the columns that exist in the data file being imported and leave the other columns unchanged

[GaryMeyers1]

Is your feature request related to a problem? Please describe. I exported just the primary key and a single column of data from a table to an XML file. I edited some of the XML records and tried to load that data back into the table. The import interface correctly mapped the two columns and I selected the INSERT or REPLACE option. However, the import failed because it didn't satisfy NULL data constraints for columns that I was not changing.

Describe the solution you'd like It would be great to add an UPDATE option to the import interface so SQLPro would change just the column(s) that are in the data file if they are different from the table. The user would be responsible for including the one or more columns in the primary key so SQLPro can find the correct records.

Describe alternatives you've considered I could export the entire contents of a table and make changes to that exported file with my editor. However, the search and replace that I did in this case would have found many false positives and taken me significantly more time to make the edits.

Additional context

Environment (please complete the following information):

• Device: iMac
• OS: Ventura 13.7.2
• SQLPro app Version: SQLPro for SQLite Version 2024.30 (Build 4374)