Ecto query fragments for Tempo.Ecto.SQLite.TempoRange columns, named after Allen's interval algebra as Tempo.Ecto.QueryAPI names the PostgreSQL range operators.

import Ecto.Query
import Tempo.Ecto.SQLite.QueryAPI

{:ok, morning} = Tempo.Ecto.SQLite.QueryAPI.probe(~o"2026-06-15T09:00Z/2026-06-15T12:00Z")
from m in Meeting, where: overlaps(m.window, ^morning)

The right-hand operand is a probe, the integer bounds of an expression probe/2 makes on the column's frame, pinned with ^. Each macro compares those bounds with the bounds the column's document holds:

• overlaps/2 — whether a span of the column shares any second with the probe.

• contains/2 — whether a span of the column holds every second of the probe.

• meets/2 — whether the column's stretch ends where the probe begins, or begins where it ends.

• strictly_before/2 — whether the column's stretch ends at or before the probe begins: Allen's precedes and meets.

• strictly_after/2 — whether the column's stretch begins at or after the probe ends.

overlaps/2 and contains/2 test each span the column holds, so the gaps between a set's members match nothing, and first compare the stretch, which the indexes Tempo.SQL.SQLite.Migration.create_tempo_range_index/2 creates answer. The bounds are whole seconds.