What application do you use to write your SQL

Content

I'm very curious as to what other people use to write their SQL. Personally I am using NotePad++ (with the SQL language setting to help with syntax).

I do feel that there could be more software assistance and there might be some more automated applications out there which allow searching the repository, automatic joins, etc. Having a tool like this would speed up my work tremendously.

Would like to discuss in this topic what you use and what you like/dislike about it.

Regards,
Maarten