objectstack-query

What problem does it solve?

This Skill solves the problem of writing correct, performant ObjectQL queries so users can fetch the right data with filters, sorting, pagination, and analytics without guessing the DSL details.

Core Features & Use Cases

• Filter expression construction: compose declarative where clauses using comparison, set/range, string, null/existence, and logical operators, including nested relation filters and cross-field comparisons via $field.
• Query shape for listing and search: define fields, orderBy, limit, offset, cursor, and OData-style top to support stable list views and APIs, including full-text search and expand (related records) specs.
• Analytics-ready queries: build aggregation queries (groupBy, having, filtered aggregations) and window-function queries (e.g., row_number, running totals) for reporting use cases.

Quick Start

Use the objectstack-query skill to design an ObjectQL list query for accounts where status is active, sorted by created_at descending, returning the first 20 records.