@wtheaker you could probably cobble something together from the plist table, this is an incomplete example of what I mean:

WITH apps_path AS (
  SELECT path, name, bundle_short_version FROM apps)
SELECT ap.name, bundle_short_version,
  MAX(CASE WHEN key = 'DTPlatformBuild' THEN value END) AS dt_platform_build,
  MAX(CASE WHEN key = 'DTPlatformVersion' THEN value END) AS dt_platform_version,
  MAX(CASE WHEN key = 'DTSDKBuild' THEN value END) AS dt_sdk_build,
  MAX(CASE WHEN key = 'DTSDKName' THEN value END) AS dt_sdk_name,
  MAX(CASE WHEN key = 'DTXcode' THEN value END) AS dt_xcode,
  MAX(CASE WHEN key = 'DTXcodeBuild' THEN value END) AS dt_xcode_build
FROM apps_path ap LEFT JOIN plist p
WHERE p.path LIKE ap.path || '%/Contents/Info.plist' 
GROUP BY ap.path;