SQL Scrapbook

ORM Studio comes with a database query tool called SQL Scrapbook. You can write any SQL statements against the database for which you have created a connection.

To open the SQL Scrapbook, right-click a connection and select Open SQL Scrapbook from the context menu.

You will be prompted for a file name for saving the contents of the Scrapbook. Then the SQL Scrapbook editor will appear above the Database Explorer view. You can type in a SQL statement like this:

To execute the statement, right click anywhere in the window and select Run SQL

The result is shown in the DB Output view that appears below the SQL Scrapbook.