The SQL Editor is the place to create, test and examine your statements. There are some additional features made for your easier life. Of course you can customize editor behavior in Preferences.
Transaction handling. Transactions in the SQL scripts (in this editor) are under user control. There is no autocommit and automatic transaction starting. You can use PRAGMAs on your own of course.
It's strongly recommended not to mix transaction started in SQL Editor and in Data Viewer. You can get some ugly collisions then.
The current statement is the SQL block under cursor or the text in editor selection.
The EXPLAIN tool is used for the current statement.
Use this action when you need to run more statements in one batch.
If there is a selection in editor, all statements in this selection will be used. If there is no selection, all statements from cursor position will be used.
The "Start from cursor" feature is very useful when your script contains an error. You can continue after correction from the middle of file.
Create a view from the current statement. The Create View Dialog with the current statement will be shown.
Create a new empty document in the editor. User is asked for save if there are any unsaved changes.
Open an existing file.
Save the current file. If the document does not have file name, the Save As dialog is shown.
Save the current file with changed name.
Open or close the Search panel in the bottom of the SQL Editor.