Mixing loaded table and manual data

Are there any details on what will happen to the data if I use Get & Transform to bring in a database table, and then add another column to put in my own metadata? If I comment on a row, but it's deleted in the data source, is the row preserved with my comment? If the number of fields change, does it just resize around my data?