Use Eclipse and the Teradata Eclipse Plugin. Make sure you install Eclipse 3.4, the 3.5 version does not work with the TD Eclipse Plugin. Please remember, this is a developer platform, but it does support completion and other good functions.
The second one I use is DBVisualizer, but there is not an environment file for Teradata for this very robust SQL query tool. Also has a very good query formater.