SQL Browser

Designer > Data > Objects > [SQL Browser]

The SQL Browser gives you a graphical interface that lets you enter a SQL query and view the results:

How it works

The navigation pane on the left shows all of the tables in your database.
Clicking the arrow next to one expands the tree, showing the columns in the table
Double-clicking a table populates the statement pane with a default query (SELECT *) from that table.
Clicking the triangle-button on the right runs the query.

Considerations

SQL syntax is not case-sensitive, except for table names and field names.
It's a good idea to enclose table names in back-ticks (`), in case the table name turns out to be in the (fairly lengthly) list of SQL Reserved Words.

For example:

SELECT * FROM `ORDER`

(When you double-click a table name, the backticks are added for you.)

Learn more