On the issue of maintaining views, we found xCase to be a real life-saver. Making table modifications really aren't such a big deal anymore. Just make your changes in xCase, and recompile the database, and you're on your way.