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.

Extends

Attributes

NameIdTypeLowerUpper
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

Released under the Eclipse Public License 2.0