title: Magento modify/add columns to model resource
body: <p>I have a module whose flat table I may need to add columns to and remove columns from. I know this can be done in setup, but I have to import data into the table nightly from a web service. The web service may occasionally change their column names.  </p>
  
  <p>First of all, does anyone know how to alter table structure in Magento without using raw SQL? Second, does anyone know the best way to do this?</p>
  
  <p>I haven't yet mastered the EAV data pattern used in Magento but would someday like to learn. Any help appreciated.</p>