Get iOS device name and architecture from device model.

device.sql

CASE
  WHEN model = 'iPhone6,1' THEN 'iPhone 5S (GSM)'
  WHEN model = 'iPhone6,2' THEN 'iPhone 5S (Global)'
  WHEN model = 'iPhone7,1' THEN 'iPhone 6 Plus'
  WHEN model = 'iPhone7,2' THEN 'iPhone 6'
  WHEN model = 'iPhone8,1' THEN 'iPhone 6s'
  WHEN model = 'iPhone8,2' THEN 'iPhone 6s Plus'
  WHEN model = 'iPhone8,4' THEN 'iPhone SE (GSM)'
  WHEN model = 'iPhone9,1' THEN 'iPhone 7'
  WHEN model = 'iPhone9,2' THEN 'iPhone 7 Plus'
  WHEN model = 'iPhone9,3' THEN 'iPhone 7'
  WHEN model = 'iPhone9,4' THEN 'iPhone 7 Plus'
  WHEN model = 'iPhone10,1' THEN 'iPhone 8'
  WHEN model = 'iPhone10,2' THEN 'iPhone 8 Plus'
  WHEN model = 'iPhone10,3' THEN 'iPhone X Global'
  WHEN model = 'iPhone10,4' THEN 'iPhone 8'
  WHEN model = 'iPhone10,5' THEN 'iPhone 8 Plus'
  WHEN model = 'iPhone10,6' THEN 'iPhone X GSM'
  WHEN model = 'iPhone11,2' THEN 'iPhone XS'
  WHEN model = 'iPhone11,4' THEN 'iPhone XS Max'
  WHEN model = 'iPhone11,6' THEN 'iPhone XS Max Global'
  WHEN model = 'iPhone11,8' THEN 'iPhone XR'
  WHEN model = 'iPhone12,1' THEN 'iPhone 11'
  WHEN model = 'iPhone12,3' THEN 'iPhone 11 Pro'
  WHEN model = 'iPhone12,5' THEN 'iPhone 11 Pro Max'
  WHEN model = 'iPhone12,8' THEN 'iPhone SE 2nd Gen'
  WHEN model = 'iPhone13,1' THEN 'iPhone 12 Mini'
  WHEN model = 'iPhone13,2' THEN 'iPhone 12'
  WHEN model = 'iPhone13,3' THEN 'iPhone 12 Pro'
  WHEN model = 'iPhone13,4' THEN 'iPhone 12 Pro Max'
  WHEN model = 'iPad4,1' THEN 'iPad Air (WiFi)'
  WHEN model = 'iPad4,2' THEN 'iPad Air (GSM+CDMA)'
  WHEN model = 'iPad4,3' THEN '1st Gen iPad Air (China)'
  WHEN model = 'iPad4,4' THEN 'iPad mini Retina (WiFi)'
  WHEN model = 'iPad4,5' THEN 'iPad mini Retina (GSM+CDMA)'
  WHEN model = 'iPad4,6' THEN 'iPad mini Retina (China)'
  WHEN model = 'iPad4,7' THEN 'iPad mini 3 (WiFi)'
  WHEN model = 'iPad4,8' THEN 'iPad mini 3 (GSM+CDMA)'
  WHEN model = 'iPad4,9' THEN 'iPad Mini 3 (China)'
  WHEN model = 'iPad5,1' THEN 'iPad mini 4 (WiFi)'
  WHEN model = 'iPad5,2' THEN '4th Gen iPad mini (WiFi+Cellular)'
  WHEN model = 'iPad5,3' THEN 'iPad Air 2 (WiFi)'
  WHEN model = 'iPad5,4' THEN 'iPad Air 2 (Cellular)'
  WHEN model = 'iPad6,3' THEN 'iPad Pro (9.7 inch, WiFi+LTE)'
  WHEN model = 'iPad6,4' THEN 'iPad Pro (9.7 inch, WiFi+LTE)'
  WHEN model = 'iPad6,7' THEN 'iPad Pro (12.9 inch, WiFi)'
  WHEN model = 'iPad6,8' THEN 'iPad Pro (12.9 inch, WiFi+LTE)'
  WHEN model = 'iPad6,11' THEN 'iPad (2017)'
  WHEN model = 'iPad6,12' THEN 'iPad (2017)'
  WHEN model = 'iPad7,1' THEN 'iPad Pro 2nd Gen (WiFi)'
  WHEN model = 'iPad7,2' THEN 'iPad Pro 2nd Gen (WiFi+Cellular)'
  WHEN model = 'iPad7,3' THEN 'iPad Pro 10.5-inch'
  WHEN model = 'iPad7,4' THEN 'iPad Pro 10.5-inch'
  WHEN model = 'iPad7,5' THEN 'iPad 6th Gen (WiFi)'
  WHEN model = 'iPad7,6' THEN 'iPad 6th Gen (WiFi+Cellular)'
  WHEN model = 'iPad7,11' THEN 'iPad 7th Gen 10.2-inch (WiFi)'
  WHEN model = 'iPad7,12' THEN 'iPad 7th Gen 10.2-inch (WiFi+Cellular)'
  WHEN model = 'iPad8,1' THEN 'iPad Pro 11 inch 3rd Gen (WiFi)'
  WHEN model = 'iPad8,2' THEN 'iPad Pro 11 inch 3rd Gen (1TB, WiFi)'
  WHEN model = 'iPad8,3' THEN 'iPad Pro 11 inch 3rd Gen (WiFi+Cellular)'
  WHEN model = 'iPad8,4' THEN 'iPad Pro 11 inch 3rd Gen (1TB, WiFi+Cellular)'
  WHEN model = 'iPad8,5' THEN 'iPad Pro 12.9 inch 3rd Gen (WiFi)'
  WHEN model = 'iPad8,6' THEN 'iPad Pro 12.9 inch 3rd Gen (1TB, WiFi)'
  WHEN model = 'iPad8,7' THEN 'iPad Pro 12.9 inch 3rd Gen (WiFi+Cellular)'
  WHEN model = 'iPad8,8' THEN 'iPad Pro 12.9 inch 3rd Gen (1TB, WiFi+Cellular)'
  WHEN model = 'iPad8,9' THEN 'iPad Pro 11 inch 4th Gen (WiFi)'
  WHEN model = 'iPad8,10' THEN 'iPad Pro 11 inch 4th Gen (WiFi+Cellular)'
  WHEN model = 'iPad8,11' THEN 'iPad Pro 12.9 inch 4th Gen (WiFi)'
  WHEN model = 'iPad8,12' THEN 'iPad Pro 12.9 inch 4th Gen (WiFi+Cellular)'
  WHEN model = 'iPad11,1' THEN 'iPad mini 5th Gen (WiFi)'
  WHEN model = 'iPad11,2' THEN 'iPad mini 5th Gen'
  WHEN model = 'iPad11,3' THEN 'iPad Air 3rd Gen (WiFi)'
  WHEN model = 'iPad11,4' THEN 'iPad Air 3rd Gen'
  WHEN model = 'iPad11,6' THEN 'iPad 8th Gen (WiFi)'
  WHEN model = 'iPad11,7' THEN 'iPad 8th Gen (WiFi+Cellular)'
  WHEN model = 'iPad13,1' THEN 'iPad air 4th Gen (WiFi)'
  WHEN model = 'iPad13,2' THEN 'iPad air 4th Gen (WiFi+Celular)'
  ELSE 'Unknown'
  END AS device,
CASE
  WHEN model IN ('iPhone6,1',
    'iPhone6,2',
    'iPhone7,1',
    'iPhone7,2',
    'iPhone8,1',
    'iPhone8,2',
    'iPhone8,4',
    'iPhone9,1',
    'iPhone9,2',
    'iPhone9,3',
    'iPhone9,4',
    'iPhone10,1',
    'iPhone10,2',
    'iPhone10,3',
    'iPhone10,4',
    'iPhone10,5',
    'iPhone10,6') THEN 'arm64'
  WHEN model IN ('iPhone11,2',
    'iPhone11,4',
    'iPhone11,6',
    'iPhone11,8',
    'iPhone12,1',
    'iPhone12,3',
    'iPhone12,5',
    'iPhone12,8',
    'iPhone13,1',
    'iPhone13,2',
    'iPhone13,3',
    'iPhone13,4') THEN 'arm64e'
  WHEN model IN ('iPad4,1',
    'iPad4,2',
    'iPad4,3',
    'iPad4,4',
    'iPad4,5',
    'iPad4,6',
    'iPad4,7',
    'iPad4,8',
    'iPad4,9',
    'iPad5,1',
    'iPad5,2',
    'iPad5,3',
    'iPad5,4',
    'iPad6,3',
    'iPad6,4',
    'iPad6,7',
    'iPad6,8',
    'iPad6,11',
    'iPad6,12',
    'iPad7,1',
    'iPad7,2',
    'iPad7,3',
    'iPad7,4',
    'iPad7,5',
    'iPad7,6',
    'iPad7,11',
    'iPad7,12',
    'iPad8,1',
    'iPad8,2',
    'iPad8,3',
    'iPad8,4',
    'iPad8,5',
    'iPad8,6',
    'iPad8,7',
    'iPad8,8') THEN 'arm64'
  WHEN model IN ('iPad8,9',
    'iPad8,10',
    'iPad8,11',
    'iPad8,12') THEN 'arm64e'
  WHEN model IN ('iPad11,1',
    'iPad11,2',
    'iPad11,3',
    'iPad11,4') THEN 'arm64'
  WHEN model IN ('iPad11,6',
    'iPad11,7',
    'iPad13,1',
    'iPad13,2') THEN 'arm64e'
  ELSE 'Unknown'
END AS architecture