This intro to EntityFieldQuery makes for a pretty clear-headed intro to, like, well, not having to set up a view for every single thing ever, or for doing things within views a little more easily at the code level.
Today I Learned
...a bit about EntityFieldQuery in Drupal