Q449 confusion about flake8-sql HOT 8 OPEN

Previously it was fine, with the latest version i'm getting same warning for similar queries from all over the code base.

from flake8-sql.

There is another query on which it is throwing Q449 token FROM should be aligned to the right of the river

SELECT col1
  FROM table1
 WHERE NOT EXISTS(SELECT col2
                    FROM table2
                   WHERE condtion)

Could that be due to this EXISTS statement?

from flake8-sql.

Hmm, I'm not sure here - it could be. Could you confirm which version it worked in, and which version you are using now?

from flake8-sql.

Previously 0.2.0 and now 0.4.0.
The case is with every exists query of the same nature.

from flake8-sql.

I think it is the exists (and also this d1a1000) - as the exists isn't being recognized as a function.

from flake8-sql.

So is this going to be fixed soon? Or if you can point me i might be able to send a fix.

from flake8-sql.

Very happy for you to send a fix, at the moment I can only point to d1a1000.

from flake8-sql.

I had a look at the function you pointed out, seems like it is working fine (had it debugged). I think the problem is here on this line or below it:

Debugged this one as well, the values (token col, depth, and previous root values) seems fine to me ( i might not be correct).

Could there be any issue with this condition?

Values (debugged):

token: FROM
token.col: 27
token.depth: 1
previous_root: SELECT
previous_root.col: 25
previous_root len+1: 7

By adding the root_keyword condition is not working (failing other scenarios), can you help me out a bit here?

from flake8-sql.