For a data-loading operation based on information that might be malformed, load
new rows into a temporary table, perform some preliminary checks, and correct
the rows as necessary. When you’re satisfied that the new rows are okay, copy them
from the temporary table to your main table.