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

osquery

has anyone spelunked into how to perhaps mash up mdls for kMDItemExecutableArchitectures to add a "kind" column to the apps table on Darwin?

this is in response to <https://www.alansiu.net/2021/11/16/script-to-find-application-architectures-on-your-mac/>

and the answer is of course you can mashem up
```osquery&gt; select count(*) from apps join mdls on mdls.path = apps.path where mdls.key = "kMDItemExecutableArchitectures" and mdls.value not like "arm64%"; 
count(*) = 44```


I wonder how cheap the mdls call is. I wonder if this can be parsed out of Info.plist or something

good question, it's not in the first info.plist I'm checking. I need to get better at profiling

The really quick way is to `.timer on` in osqueryi and see how different they look. You can also get into queryy planning.