The documentation here is useful http://drupal.org/developing/api/database
SELECT queries still work in the old style (Static queries), but placeholders are formatted differently, see http://drupal.org/node/310072
Carl Wiedemann Website design and development consulting carl.wiedemann@gmail.com | skype: c4rlww