Static vs. Dynamic Queries in Drupal 7 and the Right Syntax to Use
If you're creating a query that will need to be modified by a 3rd party or if your creating drupal.org project code then use things like db_select().

For all other use cases I prefer db_query() as the mental overhead is a lot lower.