Reporting Engine

I appreciate the simplicity of the existing reports, but I want to get more dynamically generated content specifically for our troop intranet page (hosted on TT). There are some reports, specifically on events and roster that I would like to customize with additional fields available in the user accounts. Trying to replicate the roster that SOAR had showing everyone by a few different views. I would love a sql editor for us full nerd types, with an execution limit of 15 seconds or so to not kill a server by accident.