Resolving incorrectly fails with AmbiguousColumn

Hi, seems like resolver gets confused about the context used for resolution when trying to resolve columns in nested queries and fails with AmbiguousColumn error, e.g.: select a from demo.foo where a in (select a from demo.foo);

Hey, not sure if you managed to find a fix for this. Right now, none of the original authors (myself included) are active on this project, but if you're able to get a fix going I can review a PR.