If your data is relational you could probably use a window function like `lag` or `lead`

Immich, the *arrs, audiobookshelf, calibre, pigallery2, portainer, and stable diffusion web UI, are for sure my most used.