How can we efficiently handle table additions/updates while keeping the application and database in sync dynamically?
Enumerate all relevant column names in SELECT and INSERT statements. That way, the application still works when you add columns or alter(*) data types. Dropping columns will still break your app.
*Altering to from a numeric type to a text type might still kill your app, if it can't convert the string into your app's int or float type..