Chapter 6. The queries area

This work area is the place where user defined queries are managed. The queries are any kind of SELECT, INSERT, UPDATE or DELETE queries. Queries are created using a creation druid, where all the steps required to create a query are proposed.

A query can also be created from an SQL statement, which is parsed and analysed. Parameters can be introduced in the query when a value is required but not known when the query is created. A very simple extension to the SQL has been created for that purpose, and is best illustrated by a few examples:

When a parameter is required