so I have a Python project in IntelliJ IDEA using the Python plugin, and I also do SQL stuff in there. For autocomplete purposes, I added the SQL connections to the project, and everything workd great until recently. But now, either since the 2019.3.2 or 2019.3.1 update (I'm not quite sure when it was introduced), the IDE can't resolve tables and columns anymore, and thus it marks every SQL statement in my project as an "unable ro resolve X" error, which is quite distracting and makes the scrollbar basically a big red blob on some files:
(names obviously changed for the screenshot, but it looks the same with the actual tables and columns)
However, if I select "Run query in console" and start a new session in the dialog that pops up, then it recognizes everything again, at least for the current file. In other files I then need to either open a new session or attach the one that I opened first. I definitely did not have to do this before.
Now, I'm not sure if this behaviour is intended or a bug, but either way it's pretty annoying, and makes me less likely to see the red dots when there is an actual error somewhere. Is this a bug? And if not, can someone explain to me why this changed and how I can work around this without going through every file?