I have a feature request for the SQLite command shell, which is to add a command to edit the definition of a view and its triggers (whether or not it already exists) using an external editor (such as Vim). The same can be used for editing the triggers of tables, and for the table definition itself if the table is empty. Maybe it works for indexes also.