A neat thing about csh/tcsh is that you can use history expansion with aliases. There are some legacy aliases at work that allow SQL queries from the command line using this:

  $ alias select='sqlcommand -s "select !*"'

would translate:

  $ select * from tablename

to:

  $ sqlcommand -s "select * from tablename"

(Note: I may be getting the specifics messed up as it's been a couple of years since I looked at the implementation, but the general idea is there.)