by Jonathan Daggerhart on WordPress.org
Query Wrangler provides an intuitive interface for creating complex WP queries as shortcodes and widgets. UI based on Drupal Views.

Drupal Views Editor Theme
This plugin lets you create new WP queries as widgets and use shortcodes for queries on your pages. It also allows you to override the way category and tag pages display.
Query Wrangler’s interface is highly intuitive way to create queries and will be second nature for any Drupal Views user.
This plugin will bring extreme flexibility to WordPress users with its ability to create custom queries using the WP_Query class with a user interface.
Supports:
Some examples of how you would use this plugin include: