Max SDK Glossary - answerrocket/answerrocket-python-client GitHub Wiki

Domain Model

RQL

RQL, or Rocket Query Language, is a SQL-like language that can be used to query a dataset's domain model. A RQL query gets turned into SQL for the dbms being queried.

For example, the following is a simple RQL query that gets total sales for 2023 by region:

@out transactions.amount
where date.year = 2023
group by region

RQL Name

A RQL name is a string used to identify a particular domain object. RQL uses dot notation to identify domain attributes contained by a particular domain entity. For example, transactions.amount designates the amount metric attribute on the transactions domain entity.

Dot notation is not used for calculated metrics. For example, the net_sales calculated metric stands on its own since it can perform computations on domain objects across domain entities.