Queries are traditionnaly divided in the categories: DDL (Data Definition Language) ones and DML (Data Manipulation Language) ones.
Mergeant does not yet offer any way to create databases, tables, or any other objects in a database. This will be implemented in a future version.
With the most precise knowledge of the database structure and hints of what the user wants to do, Mergeant tries to offer the best possible GUI for data management.
Usually the user defines a selection (SELECT SQL statement) query and uses it afterwards to first fetch some data from the DBMS, but also to modify, create or delete data (Mergeant then provides the associated forms to allow such manipulations).
In some very rare occasions, the user will want to create some specific query to create, update or delete data (this is not yet supported).
Mergeant also offers an area where SQL queries can be submitted, which allow virtually any possible manipulation; but this simple and direct interface does not provide any automation for data processing.