I know I am able to create Live Templates, but I think this request has larger appeal (plus I don’t even know if this is possible).
- lsq (list from SOQL) → List<Account> accounts = [SELECT (cursor position) FROM Account];
- ssq (single record from SOQL) → Account account = [SELECT Id FROM Account WHERE (cursor position) = LIMIT 1];
The thought process behind the WHERE clause cursor position was that it would be nearly impossible to know what field to filter on, but it would be convenient to have the boilerplate WHERE and = to be there already. Maybe the cursor could bring up a list of fields on the sObject and then tab could be pressed to enter the appropriate variable on the right side of the equals sign.