Feature: SELECT autocomplete

[LucyEgan]

Is your feature request related to a problem?

When writing a ""FIELDS"" WHERE, GROUP, ORDER thats against a known table (by exact string) on the closest query to the cursor, allow auto completion that will show a list of fields for that current queries table

Describe the solution

Below are example of when using autocomplete would pick the table if its been written at that point

SELECT * FROM accounts WHERE {{AUTO COMPLETE}} << shows fields for accounts
SELECT {{AUTO COMPLETE}} FROM accounts << shows fields for accounts
SELECT * FROM (SELECT * FROM accounts WHERE {{AUTO COMPLETE}}) << shows fields for accounts
SELECT * FROM (SELECT * FROM accounts) WHERE {{AUTO COMPLETE}} << doesnt show any fields as its a from a dynamic FROM

Have you considered contributing this feature yourself?

No response

Contact Details

[email protected]

Is there an existing issue for this?

• I have searched the existing issues

Code of Conduct

• I agree to follow this project's Code of Conduct