I have merged the latest code of "pgcli" used for auto complete feature in pgAdmin4. We haven't merged that code since last 2 years and they have fixed some bugs and also provided some new features:
Add support for CTE aware auto-completion.
Handle unrecognized keywords gracefully.
Support for table-qualifying column suggestions.
Add additional completion for ALTER keyword.
Better suggestions when editing functions.
Added MATERIALIZED VIEW keywords.
Completions after ORDER BY and DISTINCT now take account of table aliases.
Include arguments in function suggestions.
Add missing keyword COLUMN after DROP
I have also added some feature test for auto complete. Attached is the patch please review it.
--
AkshayJoshi
Sr. Software Architect
Phone: +91 20-3058-9517 Mobile: +91 976-788-8246
--
Thanks and Regards,
Aditya Toshniwal
Software Engineer | EnterpriseDB Software Solutions | Pune