1.)
The code completion does not work with substrings, i.e. given a table name "TEST" will be displayed only when typing TE..
If SOME substring of TEST is uses, e.g. start typing ST the table name is not found (or any other object).
Is it possible to add this feature? Oftenly users cannot exactly remember the name of a table exactly so this w'd be quite useful (highlighting the typed string additionally at best).
In a bit more detail I think it'd be most useful if the result tightens with every typing step more, i.e. a filtering of objects occurs with each additional character typed (on the complete string). So, for the example test (in my view) it should be found by typing in T, TE, TES, TEST, E, ES, EST, S, ST.
To discuss if makes sense to allow additionally string combinations like:
TT, TS, TST, ET, SET, TSE, TSET.
2.) I noticed command completion in a WHERE clause sorts columns to the top which is great, but in general some kind of highlighting of spicific types with a dedicated colour, e.g. for columns, or generally using a symbol for the object type w'd make it even better. I think the symbol approach w'd be clearer than using colours, e.g. a "table symbol" for a table a "glasses symbol" for views...
Showing a VIEW with (VIEW) is very useful already but maybe this can still be extended further, e.g. by displaying the Table / View in sqare brackets behind the column name so it's clear what object the displayed columns belong to. Example: Table TEST with column testCol --> TEST testCol varchar(80) [TEST]
Maybe objects not belonging to the table / view used in the statement can be filtered out completely so the list of objects reduces a lot.
