Let say I have code:
FROM A a
JOIN B b ON a.bid=b.id
Now I place the cursor after “SET” and invoke code completion (ctrl + .).
Column list is displayed from table A, which is wrong. I am updating table B, not A.
If I change an order of tables after FROM everything is ok - columns from table B are shown.
It seems that the first table after FROM is always considered, not an aliased one.