Stheven Cabral5,302 Points
What program do analysts use to write SQL?
Apologize for the beginner question. What program do analysts use to write SQL? For example, programmers use sublime or atom to write python code? Is it similar for SQL? Does one need a text editor in order to write SQL? If yes, what text editors are the most common? If no, where do you actually write SQL?
adrian miranda12,196 Points
As Jan already said, you can use many different editors to create SQL. There isn't any one editor that most people use.
Perhaps the most obvious place to start looking is with your Database vendor. Many of them provide free editors that are fairly decent, eg Oracle provides sqldeveloper, and Mysql provides "mysql workbench". These tools are very common. They don't just allow you to easily format your code, but they can also connect to the database and run your code. They can usually show you the output in neatly formatted tables, and can also give you information about how well your SQL ran.
Another thought is to use your favorite editor, if it has support for SQL (many do, though not all).
Jan Oberreiter69,420 Points
you can write it with any editor, but those are especially for SQL: