It's been a good while since I've fiddled with anything SQL, even then it was only rather simple stuff like managed account data and post data for websites.
That being said I will be diving into it again soon™ when it becomes needed for some of my projects that are in the works and should be done soon™
There's a lot you can do with HIVE-SQL, it's adding the correct parameters to get what you need. I will be brushing up on it, but will avoid using it in the BOT when I can call the condenser (or BEEM at a push) API's.., unless they slow things down.