I've always just typed constants and SQL with my pinky on the left Shift key. It feels easier than having to toggle Caps Lock all the time.

In situations where I'm excited and messaging my friends to yell, I've typed entire sentences mostly holding down Left Shift. After some experimentation, it looks like even for normal sentence capitalization, I never use Right Shift unless I'm typing one-handed.

I have Karabiner Elements configured to toggle CapsLock with the LShift+RShift combination. Pretty handy, and unlikely to ever hit it accidentally.

The new versions of sql don’t require capital letters on all the keywords. :p

More seriously color syntax highlighting works far better than capitalizing almost everything in sight. I’d recommend dropping the caps convention.

Karabiner Elements is free and will let you bind Esc to Caps Lock. It actually allows general remapping for instance I use a Microsoft Sculpt keyboard with my Mac and have that stupid menu key remapped to be a second Option.

I stopped using caps in SQL a few years ago, it changed my life for the better

Using Karabiner, I have caps lock mapped to escape, and shift+caps lock toggles caps lock.

Yeah I SHIFT everything capital letters. Feel better than Capslock. Not a Mac user but I wish my laptop has semi-full size keyboard (that includes everything excluding the number pad), but that's too big for laptops I guess :(

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.

I’ve been doing this, as prompted by being assigned a touchstrip MacBook at my last job.

Have to say I was able to retrain pretty quickly. jj is now my first instinct even on full-sized keyboards. I now think it’s really an improvement. All about staying on that home row as much as possible..

Except that doesn’t work in every other app that doesn’t understand vi keys.