I'm using DB2 in the IntelliJ DB console and SQL files and I get red highlighting across all my column names.
I had a look at https://intellij-support.jetbrains.com/hc/en-us/community/posts/360003671819--Unable-to-resolve-column-inspection-error-in-DB-console but nobody picked up on my post perhaps because that is PhpStorm. So I came over here.
I've followed your instructions to set up the SQL Resolution Scopes in my settings, but that doesn't let me add any mappings except for the whole project.
This is a maven project with nested modules, which I am suspicious of - is that relevant?