SQL Snippets
Queries, joins, windows, indexes and migrations for the built-in SQL language.
Type a prefix and press Tab. 10 snippets.
| Language | Prefix | What it inserts |
|---|---|---|
| SQL | sel |
SELECT |
| SQL | ins |
INSERT |
| SQL | upd |
UPDATE |
| SQL | del |
DELETE |
| SQL | ct |
CREATE TABLE |
| SQL | lj |
LEFT JOIN |
| SQL | gb |
GROUP BY with count |
| SQL | win |
ROW_NUMBER over a partition |
| SQL | idx |
CREATE INDEX |
| SQL | tx |
A transaction |
This extension runs no code and asks for no permissions.