I have noticed a trend in existing addons to do raw SQL queries instead of using built in methods. For example, all of the "Latest Threads" examples do this by using the DB instead of using XF's findNewThreads() function or similar.
I am mediocre at best at PHP, and absolutely confused when it comes to OOP, but I also couldn't find any threads here about doing this. Is it possible to take this approach? In this example it would make sense because it would allow for the user to only see threads he is permitted to see (vs say, Moderator Chat forums).
Any pointers would be lovely.