Schema changes made directly to the db will *not* be reflected in your web2py app. Best to edit your models and migrate. Data edits will work fine (except possibly if you violate and validations).
I don't have much of an opinion on the matter but some folks may advise against SQLite as a production db.