What problem does it solve?
This Skill enables building and executing complex CRM queries across multiple entities using a structured query language, eliminating manual scripting and repetitive data pulls.
Core Features & Use Cases
- Structured, SQL-like queries: from, where, include, select, orderBy, groupBy, aggregate, and limit constructs to drive powerful data retrieval.
- Multi-entity joins & relationships: fetch related entities in a single, optimized query for comprehensive insights.
- Advanced filtering & aggregation: supports complex boolean logic, counting, sums, averages, and grouping by status or other dimensions.
- Use Case: analysts can perform cross-entity analyses (e.g., total deal value by stage, active leads by source) without writing custom scripts.
Quick Start
To fetch the first 10 persons: { "from": "persons", "limit": 10 }
You can extend to filtered results, includes, and aggregates, e.g., {"from": "opportunities", "where": {"path": "amount", "op": "gt", "value": 10000}, "aggregate": {"totalValue": {"sum": "amount"}}, "limit": 100}
