Views 2 discussion at Drupal Camp NYC 5

Views 2 Relationships: Let's you get information that's one step away.

For instance, you can get content based on when users joined or something.

Add a relationship for Queue.
Add the Questionable Content queue.

Now we can use the in-queue filter: it has to be in that queue to show up in the view.

pretty slick.

And then you can sort for nodequeue.

Generally if you're thinking of writing an SQL filter do do what a views does, you can figure it out yourself.

I'm showing list of projects, writing my own query to get this information elsewhere in the database

Creating your own filter for Views 2 (this is code).

Tell views where to look for your include file using hook_views_handlers.

And go.

Resolution