You can use - where “default.eventing.eventing” is the storage location you have defined for your eventing functions:
SELECT e1.*, millis_to_str(e2.due*1000) due
FROM default.eventing.eventing e1 LEFT OUTER JOIN default.eventing.eventing e2 ON e1.alr = meta(e2).id
WHERE e1.alr IS VALUED;
to list timers waiting to fire.
(Obviously a suitable indices are needed for such querying.)