query_aql
Query an Azquo database using AQL (Azquo Query Language).
AQL works with row headings, column headings, and context — all as nested string arrays. Each inner array is one "heading expression" (a cell formula in the spreadsheet model).
Example — get monthly sales figures by product: rowHeadings: [["children of Products"]] columnHeadings: [["Jan", "Feb", "Mar"], ["Sales"]] context: [["2024"]]
The response contains: rowHeadings — resolved row labels columnHeadings — resolved column labels context — resolved context rows — 2D array of cell values (one entry per [row][col]; raw types: string|number|boolean|null) rowCount, columnCount, truncated — pagination info (maxRows default 1000)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| context | Yes | Context expressions as a 2D array — use [[]] if no context needed | |
| options | No | Engine options (rowLimit, columnLimit, sortRow/sortColumn, rowLanguage/columnLanguage, ignoreHeadingErrors, valueFormat, etc.). Omit for defaults. | |
| database | Yes | Database name to query | |
| rowHeadings | Yes | Row heading expressions as a 2D array of strings | |
| columnHeadings | Yes | Column heading expressions as a 2D array of strings |