Actually we do have a lookup at search time. It's a bit limited but could help. See Retrieve a runtime field | Elasticsearch Guide [8.10] | Elastic
I did a demo of this 2 weeks ago for the elastic daily bytes 
2 Likes