An SQL repository can define derived properties, where one repository item derives property values from another repository item or from another property in the same item. Derived properties are important to data models that use a tree structure, where certain property values are passed down from other properties.

Note: Using derived properties can affect performance: the more complex the derivation, the greater the likely impact.