Query¶

Defines a query to retrieve data.

• Query.Columns

An array of columns to include in the result set.

• Query.MaxLength

The maximum number of rows to return. If not set, all rows are returned.

• Query.Order

An array of order expressions to sort the results.

• Query.Parameters

Additional parameters to pass to the query.

• Query.Start

The starting index for the rows to return.

• Query.SubQueries

An array of sub-queries to include in the result set.

• Query.TargetSchema

The name of the schema to execute the query against.

• Query.TargetTable

The name of the table to execute the query against.

• Query.Where

The criteria to filter the query results.

• Query.XPath

The XPath expression to export the data to.