When you first start the editor, the following tabs will be available:
When you click Execute, the SQL code of the currently visible tab will be executed. You can also execute just part of the code simply selecting part of the script and clicking Execute. You will see the results and possible error messages on the lower part of the page.
You can execute multiple statements at once by adding a command delimiter between the commands. The delimiter for MySQL is '$$' and 'go' for MS SQL Server, Sybase ASE and SQL Anywhere.
When you create myDBR reports, you often call other procedures, functions or want to see table definitions. If you highlight a procedure name, function name or a table name and click Show Object, you will get the source code/table definition in a new tab. This allows you to see parameters / table definitions you might need in the report making.
Similarily you can highlite a myDBR command and click Show Object and you will be shown manual page of that particular command so you can check the usage and parameters.
To open the preferences, click the cog-icon in top right. The preferences there are:
You can have a separate window for SQL Editor open and run the report on another window while you work. This way you will see the changes immediately after the browser refreshes.