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

osquery

TL;DR I want the output of this if I could say, join the programs table to something
```WMIC.exe datafile "C:\\Program Files (x86)\\Google\\Chrome\\Application\\chrome.exe" list full


AccessMask=
Archive=TRUE
Caption=C:\Program Files (x86)\Google\Chrome\Application\chrome.exe
Compressed=FALSE
CompressionMethod=
CreationClassName=CIM_LogicalFile
CreationDate=20240312182146.364332-420
CSCreationClassName=Win32_ComputerSystem
CSName=TOMLARKIN23B2
Description=C:\Program Files (x86)\Google\Chrome\Application\chrome.exe
Drive=c:
EightDotThreeFileName=c:\program files (x86)\google\chrome\application\chrome.exe
Encrypted=FALSE
EncryptionMethod=
Extension=exe
FileName=chrome
FileSize=2118944
FileType=Application
FSCreationClassName=Win32_FileSystem
FSName=NTFS
Hidden=FALSE
InstallDate=20240312182146.364332-420
InUseCount=
LastAccessed=20240312182146.364332-420
LastModified=20240311200100.392708-420
Manufacturer=Google LLC
Name=C:\Program Files (x86)\Google\Chrome\Application\chrome.exe
Path=\program files (x86)\google\chrome\application\
Readable=TRUE
Status=OK
System=FALSE
Version=122.0.6261.129
Writeable=TRUE```