We use the Views UI a lot to create custom pages, blocks, etc. Sometimes it does not give us exactly what we want and we would like to modify the generated sql query. It's possible to achieve this through the 'views_query_alter' hook.
Views can have RSS feeds so that users can read the items in their news reader as they get added to the view.
dumping ground for bits of documentation on Views2.