Code Completion Proposal Help

[MarioR83]

I recently updated to CE Version 25.1.4.202508031529, i can't recall my previous version but it was from late 2024).

Is there a way to have the code completion proposals show me column name when I start typing? Currently I get prompted with functions first, then I need to backspace and then the list of column names shows. (on previous version i would be shown table names by default)

Current behavior:
When i start type column name... i get proposals for functions

When i backspace/deleted what i typed... column names show

When i start ti type again... column names show

[TB-HunBoka]

Can you try to go to the settings -> Editors -> SQL Editor -> Code completion -> Completion Engine -> select Legacy.
And enable "Activate Hippie Engine for autocompletion".
This should give you the same result.

[ged-yuko]

Also note that Legacy completion engine doesn't work for complex queries (like with CTE and subqueries), doesn't handle composite types, etc.

If there is a scenario where Semantic completion engine stops working for you, it would be better to report and show the example query text, with which the problem is being observed.

Looking at the screenshots provided, where column names are not highlighted, it seems semantic analysis either failed (it would be nice to report!) or disabled for some reason, which leads to missing proposals with Semantic completion engine.

[TB-HunBoka]

Finally I found why the semantic completion engine failed on my use case. But it's a bit different from what MarioR83 posted, so my comment might not help you. But let's see. I will open a bug ticket about my problem.