Perhaps the missing piece is this: There is typically no data being "stored" anywhere with osquery. The tables you query are "virtual tables" that generate their data on the fly.