RECURSE(...)

All functions > ARRAY OF ROWS > RECURSE(...)

Produces an array of rows by iterating a seed ROW, optionally traversing entity relationships

Syntax

ROW(...).RECURSE(
  [ WITH local_binding := expr, ... ]
  SELECT field_definitions
  [ WHILE condition ]
  [ VIA field BIND TO feature FOLLOW feature ]
  MAX_LEVEL n
)

Related Functions

Last update at: 2026/05/26 17:22:09