Here is half your answer, how to add a new column:

$= $Connection.Execute("ALTER TABLE Table1 Add SerialNumber VarChar(40);")

Thinking about the best way to detect whether the column is missing though ... anybody ?