I've been crafting some SQL to query the Raiser's Edge database. If you want some tips then let me know.
Here's one for nothing: not all ids link back to the CONSTITUENT table, usually its RECORDS.