SQL editor: Autocomplete

[insmac]

Is your feature request related to a problem?

Important: This is meant to be implemented only after questdb/questdb#1483 (Migrating the core to Monaco Editor) is done.

Whilst Monaco Editor provides autocomplete out of the box, it only has enhanced IntelliSense support for languages such as JavaScript, for SQL it's only within the context of the current buffer, i.e. it won't suggest phrases like SELECT if they haven't been used in the buffer before.

• Auto complete SQL keywords + QuestDB keywords from @questdb/sql-grammar
• Auto complete table names
• Auto complete column names for a given table
• Auto complete symbol values

Describe the solution you'd like.

Leverage Monaco's built-in autocomplete engine and extend it with new features.

Describe alternatives you've considered.

No response

Additional context.

No response