New Function Neighbor(value, Offset[, Default_value])

Why it matters

This feature provides an easy way to retrieve adjacent values in a column without complex window functions or self-joins, enabling efficient data comparisons and calculations that depend on neighboring rows.

How to use it

Use the neighbor function by specifying the target column as value, an offset integer to indicate how many rows ahead (positive) or behind (negative) to peek, and optionally a default_value to return if the neighbor does not exist. For example:

SELECT value, neighbor(value, 1) AS next_value, neighbor(value, -1, 0) AS prev_value FROM table