query-language

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}