Query Wrangler aims to bring the power of Drupal Views to WordPress. It provides a user interface for creating and templating custom WordPress queries (WP_Query). Each query is available as a WordPress widget and a shortcode for easy implementation.
It started as an attempt to emulate Drupal Views functionality into WordPress, but now it tries to adapt more to the WordPress way of doing things. The future of this plugin is to be the Views that WordPress deserves.
Discussion