RELATED

All functions > CORE > RELATED

Joins a feature or an aggregation using a key as base

Signatures

Returns: The joined feature value

RELATED(base: FEATURE, add: FEATURE) → T
sql
ParameterTypeRequiredDescription
baseFEATUREYesBase feature to use for binding
addFEATUREYesFeature to add

Notes

  • RELATED is syntactic sugar for EXTEND with automatic wrap/unwrap
  • RELATED(joined_feature VIA base_feature) expands to: EXTEND(joined_feature AS joined_field WITH ROW(base_feature AS field_name))[joined_field]
  • Avoids the manual ROW construction and field extraction needed with EXTEND
  • Will be rewritten to EXTEND/EXTEND during query processing
Suggest changes to this page
Last update at: 2026/03/03 16:47:38
Last updated: 2026-03-03 16:48:19