dt-dql-essentials

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