Code Completion is a great time saver, but it doesn’t seem to work with correlated subqueries. Tables outside the subquery’s parentheses do not show up as options.
For an example, in the following SQL, the Employee table (aliased ‘E’) does not show up in the completion options in the subquery when I try to add the ‘E.Department_ID’ column to the WHERE clause)
SELECT Employee_ID FROM Employee E WHERE NOT EXISTS (SELECT 1 FROM Department D WHERE D.Department_ID = E.Department_ID);
**Is there a plan to add this to a future release?