RelationalQuery
Abstract base class for queries that produce relational result sets suitable for SQL generation and relational database operations. RelationalQuery extends the base Query with SQL aliasing capabilities, enabling proper table and column reference management in generated SQL statements. This class serves as the foundation for concrete query implementations that interact with relational databases, including direct table access, custom SQL views, and in-memory relational data structures. The relational nature enables standard SQL operations like joins, filtering, grouping, and sorting, while maintaining compatibility with OLAP-specific requirements like dimension member loading, hierarchy navigation, and measure aggregation.
Extends
- Query 🔗
Attributes
| Name | Id | Type | Lower | Upper |
|---|---|---|---|---|
| alias | false | EString | 0 | 1 |
| Optional SQL table alias for this query when used in joins or complex SQL statements. The alias provides a short, unique identifier that can be referenced in column expressions, WHERE clauses, and join conditions, enabling clear and unambiguous SQL generation especially when the same table appears multiple times in a query or when working with long table names. When not specified, the OLAP engine may generate automatic aliases based on the query ID or table name to ensure SQL correctness. | ||||
References
| Name | Type | Lower | Upper | Containment |
|---|