that's why for similar APIs (think FIM + virustotal as an example) it is useful to combine the two sources in a server. osquery provides the first 3 columns, effigy provides the

*_latest

ones and the server implementation is what glues them together