Skip to content

Feature request: add autocompletion for columns names in the Execute SQL window #1242

@SilvioGrosso

Description

@SilvioGrosso

Hello everyone,

Please, add the autocompletion for columns names in the Execute SQL window.
This is especially handy with Sqlite tables with huge amounts of columns :-)

In essence, whenever you type your SQL code in the Execute SQL window, it would be useful to get automatically the option to choose, by pressing enter on your keyboard, the name of your column.
With PostgreSQL, I have worked with pgcli in the past [1] with the autocompletion nicely implemented.
As regards, open source softwares, Dbeaver implements this feature beautifully [2] as well.

Here is a short video I have recorded to show this option with Dbeaver (on Windows 10) together with Sqlite databases:
https://www.dropbox.com/s/r1vmzjfw05ifhi2/DBEAVER_AUTOCOMPLETION_COLUMNS_NAMES-SQLITE_TABLE.mp4?dl=0

P.s: YEP, I am aware this is a geeky teachie request: bear with me :-)

[1] https://github.com/dbcli/pgcli
[2] https://dbeaver.jkiss.org/

Metadata

Metadata

Assignees

Labels

bugConfirmed bugs or reports that are very likely to be bugs.enhancementFeature requests.

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions