Add join functionality between tables TA and TB based on ID and proximity (temporal, geographic)

[n-voisine]

We need to implement a new feature that allows joining two tables, TA and TB, which share the same ID. The join should also consider a temporal variable T, where:

For each record in table TA, the system finds the record in table TB with the same ID and the closest T value.
The match should only be valid if the T value in TB is within a specified interval, i.e., within ± DeltaT of the T value in TA.

The goal is to add the variables from table TB to table TA based on this temporal proximity condition, enabling more accurate and relevant data merging.

Acceptance criteria:

The join is performed based on matching IDs.
The closest T value in TB is selected for each record in TA.
The T value in TB must be within ± DeltaT of the T value in TA.
The new variables from TB are added to TA accordingly.

on pourrait imaginé une fonction joinTemporalEntity(TA,TB,TS,DELTAT) et joinTemporalTable(TA,TB,TS,DELTAT)

et dans le futur quand on aura un type coord_GPS joinGPSEntity(TA,TB,gps,Distance) et joinTemporalTable(TA,TB,gps,Distance)