yes, in version 4.0.2 by default the automatic completion is restricted to when the list of completed names is at 10 hits or fewer. This is configurable in the preferences.
Otherwise, type, wait for the preference defined delay, then the list will appear.
Works best in fully constructed queries, such as
This should bring up a list of tables/views in HR that you could query from.
in "code editor" > "completion insight"