IIRC, that is because the backing database is RocksDB which is only intended to have concurrent access from a single process. Most people are scheduling queries to run on

osqueryd

and ingesting the results (especially for event-based tables like file_events) so it's not much of a problem generally.