Hey folks! I just published an article on finding the approximate manufacture date of a macOS device by parsing its serial in osquery. This is a great demonstration of how you can use CTEs to create temporary lookup tables, if you weren't already aware of this awesome little super-power! https://blog.kolide.com/determining-mac-hardware-manufacture-date-using-osquery-54091a9cccbb