Eclipse is not my primary IDE, but I do find it very useful for editing ANT project definitions, especially the outline view.
I use generic projects in Eclipse Juno 4.2 to manage collections of DDL scripts, but I did miss SQL syntax highlighting. Well, no more!
I found this plugin on the Internet: http://blog.debertshaeuser.com/index.php?page=eclipse-sql-editor.
Just download the jar and put it in the eclipse/plugins folder, then re-start Eclipse. It works great: