Multiple sql accounting queries

Hi guys, I'm looking into the best way to implement multiple sql queries for accounting... what is the "proper" way of doing this (besides evil sql magic), can I define another sql instance? How do I go about mapping queries to that etc? Thanks, Joe