Templates for common SQL idioms

[JakeWharton]

Similar interaction to what you get with fori in code. Maybe you do joinl and get

LEFT JOIN [<source>] ON [<clause>]

with the cursor selecting <source> and then pressing tab goes to <clause>.

[JakeWharton]

pk becomes PRIMARY KEY if inside a column definition. Otherwise it becomes PRIMARY KEY ([columns]).

fk becomes REFERENCES [table]([column]) if inside a column definition. Otherwise it becomes FOREIGN KEY ([column]) REFERENCES [table]([column]).