Hi! I'd like to compile osquery into my own application as a sqlite module and query it directly through sqlite. Is this remotely possible?

Not really possible. No.