QGIS Temporal Controller - last/most recent object within a temporal frame

i am working with temporal controller for just a cluple of days – before i’ve been using time manager. right now i am searching for a way to display the last/latest/most recent feature within a time interval which is defined by the "Frame" settings of the "Temporal Controller" GUI.

finally it should look like img_01 (see below):
the yellow trace is implemented already and works fine.
but the red dot is the thing i am asking for …

within my time frame of 15min the temporal manager returns a set of 3 (sometimes 4) points. and i would like to implement kind of a selection algorithm that returns just this one point, which is the last one within the frame i.e. the one with the MIN value of an expression that could look like @map_end_time - "points_time"

i have been trying differnet things but

• i could not find out how to get a collection/set of geometries within an QGIS expression by using "geometry generator"
• and even if i could find out how to get that collection i would not be able to select the one last point with the max-value of the time-field
• i’ve tried to use the temporal controller variables @map_start_time and @map_end_time in QGIS Query Builder to select features on the layer level – but i could not find a way to get along with the syntax for handling date and time SELECTs on geopackage-data within the Query Builder-environment
  e.g. how a select of to_datetime(@map_start_time + '2 Hour') could be translated into QGIS Query Builder syntax ? (the expamle works fine in QGIS expressions -> see labels/last line out of 4 in img_02)

img_01:

img_02: