Osquery uses basic SQL commands to leverage a relational data-model to describe a device.

osquery

For the free version is there an API only account that I can use that the session wont expire? Or is this a paid only feature?  (the website mentioned API only access for automated queries)

Free users can absolutely create API-only users! Hope this helps.

<https://fleetdm.com/guides/fleetctl#using-fleetctl-with-an-api-only-user:~:text=user%27s%20shell%20history.-,Using%20fleetctl%20with%20an%20API%2Donly%20user,-When%20running%20automated|https://fleetdm.com/guides/fleetctl#using-fleetctl-with-an-api-only-user:~:text=user%27s%2[…]th%20an%20API%2Donly%20user,-When%20running%20automated>