The problem with using a view is that Web2py/Django/Rails is that they all expect a unique id field in the result set. If you create your views with a dummy id field you may be able to use it as a 'pseudo' table. However you still need to somehow populate that field with a unique value. Also understand that you cannot update the view - which you probably don't want to do anyway.
BrendanC