Skip to content

SqlStatement ​

Contains SQL expression text and database dialect information for database-specific SQL implementations. SqlStatement enables OLAP schemas to support multiple database platforms by providing dialect-specific SQL expressions.

Attributes ​

NameIdTypeLowerUpperDefault
dialectsfalseEString0∞
Collection of database dialect identifiers that specify which database systems this SQL statement applies to. Examples include 'mysql', 'postgresql', 'oracle', 'sqlserver'. When empty, the statement applies to all database types.
sqlfalseEString01
The actual SQL expression text that defines this statement. Contains database-specific SQL syntax that will be executed or used in query generation by the OLAP engine.

References ​

NameTypeLowerUpperContainment

Used by ​

  • TableQuery🔗 → sqlWhereExpression
  • SQLExpressionColumn🔗 → sqls
  • SqlView🔗 → sqlStatements

ClassDiagramm ​