I either hold down shift for short vars or use the vim uppercase motion. After a variable is declared then I use autocomplete.

SQL does not have to be written in uppercase generally. If you care, use an autoformatter.