chaprola_query
Run SQL-free queries on data files with filtering, field selection, aggregation, sorting, joins, pivots, and Mercury scoring. Extract insights from structured data without writing SQL.
Instructions
SQL-free data query with WHERE, SELECT, aggregation, ORDER BY, JOIN, pivot, and Mercury scoring
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file | Yes | Data file to query | |
| join | No | Join: {file, on, type, method} | |
| limit | No | Max results to return | |
| pivot | No | Pivot: {row, column, values, totals, grand_total} | |
| where | No | Filter: {field, op, value}. Ops: eq, ne, gt, ge, lt, le, between, contains, starts_with | |
| offset | No | Skip this many results | |
| select | No | Fields to include in output | |
| mercury | No | Mercury scoring: {fields: [{field, target, weight}]} | |
| project | Yes | Project name | |
| order_by | No | Sort: [{field, dir}] | |
| aggregate | No | Aggregation: [{field, func}]. Funcs: count, sum, avg, min, max, stddev |