sqlup-mode is a minor mode for emacs. Its sole purpose is to make your life easier when writing SQL.

SQL, by convention, uses upper-case keywords, although lower-case works just as well. As humans, the separation between upper-case and lower-case helps scan and parse the code much more quickly.

This mode has been extended to upcase keywords when using redis-mode as well.

I gave a talk (slides) at the emacs NYC meetup, and it was decided that sqlup is pronounced skloop.

Content TK. Pull request welcome. Same as all other emacs packages, really.

sqlup-mode is NOT YET on Marmalade.

Here follows an example setup to activate sqlup-mode automatically when entering sql-mode or sql-interactive-mode:

;; Capitalize keywords in SQL mode
(add-hook 'sql-mode-hook 'sqlup-mode)
;; Capitalize keywords in an interactive session (e.g. psql)
(add-hook 'sql-interactive-mode-hook 'sqlup-mode)
;; Set a global keyword to use sqlup on a region
(global-set-key (kbd "C-c u") 'sqlup-capitalize-keywords-in-region)

Activate the minor mode with M-x sqlup-mode and you can just start typing. The minor mode will be triggered by the following keys:

• SPC
• (
• ,
• ;
• RET
• '

Select a region and just call M-x sqlup-capitalize-keywords-in-region. Magic.

I made the choice of only triggering the word-scanning when a particular keypress happens specifically because I don't want to see the word "ORde" typed when I'm typing "ORDER", and I didn't know a simple way to do it. I believe that in practice, this is good enough.