dt-dql-essentials
Installation
SKILL.md
DQL Essentials Skill
DQL is a pipeline-based query language. Queries chain commands with | to filter, transform, and aggregate data. DQL has unique syntax that differs from SQL — load this skill before writing any DQL query.
When to Load References
Before working on specific tasks, load the relevant reference:
| Task | Required Reading |
|---|---|
| Field names, namespaces, data models, stability levels, query patterns | references/semantic-dictionary.md |
| Query optimization (filter early, time ranges, field selection, performance) | references/optimization.md |
| Smartscape topology navigation for discovering relationships between entities | references/smartscape-topology-navigation.md |
summarize and makeTimeseries patterns (bucketing, calendar months) |
references/summarization.md |
Array and timeseries manipulation (arrayFilter, collectArray, iterative) |
references/iterative-expressions.md |
Conditional logic (if/else chains), coalesce, string/date helpers |
references/useful-expressions.md |
in operator (subquery), full @ time alignment unit table |
references/operators.md |