[Squirrel-sql-users] Questions & proposals

[<dev...@ro...>]

Hi,

working with databases requires quite often to use one of the  
following sql "patterns":

SELECT * FROM  WHERE
INSERT INTO () VALUES()
UPDATE  SET  WHERE
DELETE FROM  WHERE

Is it possible to implement a small piece of code so that each of  
these "prototypes" will be created in the sql command window, e.g.  
CRTL + ALT + S for the SELECT statement?


The script plugin doesn't seem to support delete, update and select *.

Please, is it possible to add these operations, too?



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).

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.

Showing a VIEW with (VIEW) is very useful already but maybe this can  
still be extended further.

Many thanks

Robert