Have you used GlideQuery? If not, give it a go, it is an improved API to query the database. It is a wrapper over GlideRecord and helps with improving the quality of your queries and also warns against some common pitfalls.

However, at the end of the day, it is a wrapper over GlideRecord, so use but don't be mean to our poor gr.

Exchange Wisenheimer