By having a default value (non-null) for each declared type of those columns. Or, the user must define a default value in the query itself. Yes, tedious; but,

By having a default value (non-null) for each declared type of those columns. Or, the user must define a default value in the query itself. Yes, tedious; but, precise and forces the programmer to really prepare for the "unknown" scenario.