<database> / <query>

Any SQL query that is valid for the database.

For example:

<database driver="oracle.jdbc.driver.OracleDriver"
       url="jdbc:oracle:thin:@host:1521:salesdb"
       user="joe"
       password="password"
   <query>
     select * from SalesOrders
   </query>
</database>

Query strings that contain XML meta-characters such as > must be marked as CDATA to prevent the XML parser from interpreting it. For example:

<query>
<![CDATA[
  select * from SalesPipeline where confidence > 0.9
]]>
</query>

The field names and types (used by the map elements) are taken from the column names and types of the query result set.