I too really enjoy third party tools and can use them where I work. I particularly use Redgat SQL Prompt for SQL Development. I really enjoy it and the tool has certainly saved me a lot of time. I don't know every statement, especially a lot of the mundane ones. SQL Prompt has good shortcuts that lets me get right to a core layout that I can work with and without reference.
I really enjoy JetBrains and their suite of IDE's. One of the major concerns I've had with them is the fact there are so many open source (free) options out there for both Python and even SQL. Thus, why pay for one when you have those free options out there? Well, I pay for PyCharm for Python because the tool has so many great features other free tools do not have for Python. Notepad++, Sublime Text, Atom, and Spyder. However, most of these are just text editors and not fully integrated IDE's like PyCharm. Therefore, paying the extra money per month is well worth the time saved.
The cool thing about JetBrains that I like is they offer a monthly billing model now that includes all of their IDE's, not just the one you want. While I have dabbled into other languages, others may not. But the idea that if I ever start working in Java, PHP, C/C++ and even need a Linux based SQL IDE, JetBrains has options that are already included in my monthly payment. I just go, download, and enjoy a fully licensed copy.