The view is better considered to be an arbitrary SELECT query. Anything that could be expressed with such a query can be made into a view. Try it! I once tried to include parameters in a view, to be bound to values when the view was used in a query, but SQLite rejects it. As far as I could see from the documentation, it should have been allowed. But it is not.