• This Tab is for the advanced users who are familiar with the SQL syntax.
• To prevent accidental damage to the database when executing statements of type Update/Insert/Delete user must explicitely mark the checkbox "This statement is of Update type" before running such query.
• The used database is of HSQLDB type with the single quotes for literals. E.g. to extract exchanges which names start with "A", use the following query:

select * from exchanges where name like 'A%' ;

• Pressing "CTRL+E" when in the SQL text area will trigger statement execution.

• Load Schema - will load the current database structure defintion - table, column names.
  

• Select All from table - executeSQL statement to show all entries in the table selected in the schema tree. It is suggested to run "Select count(*) from table" first to know the number of the returned records. The large datasets might take a while to load.
  

• Select Count(*) from table - shows how mnay records are currently in the table.

• Export grid to a comma delimited file - creates a file with the data from the grid. One line per row, with the entries separated with commas. Such files can be imported to Excel for accounting purposes.

• This statement is of update type - check this field if you want to run statement of type "update/insert/delete".

• Change sql font - allows you to specify parameters (size, font, bold) of the font used for the SQL text panel.

• Double click on the grid header to sort data by the selected column.

• Drag the column dividers to make a column wider/smaller.