DataGrip isn't perfect but it's radically changed how I work with SQL. It makes writing queries so incredibly easy, with a god mode autocomplete. JOINs are so easy <3

Does anyone knows of vim or emacs plugins that do similar heavy lifting? Preferably decent at T-SQL