How Device Label is mapped against Device types in Matomo ?

For eg :: Desktop = 1 , Smartphone = 2 , Tablet = 3 etc. In the Database ( matomo_log_visit table ) , I could see only Device models & brands are mapped against Device type . That does not help me to categorize the device. I am looking for something similar to the below.

CASE
WHEN config_device_type = 0 THEN ‘Unknown’
WHEN config_device_type = 1 THEN ‘Desktop’
WHEN config_device_type = 2 THEN ‘Smartphone’
WHEN config_device_type = 3 THEN ‘Tablet’
WHEN config_device_type = 4 THEN ‘Feature phone’
WHEN config_device_type = 5 THEN ‘Console’
WHEN config_device_type = 6 THEN ‘TV’
WHEN config_device_type = 7 THEN ‘Car browser’
WHEN config_device_type = 8 THEN ‘Smart display’
WHEN config_device_type = 9 THEN ‘Camera’
WHEN config_device_type = 10 THEN ‘Portable media player’
WHEN config_device_type = 11 THEN ‘Phablet’
WHEN config_device_type = 12 THEN ‘Smart speaker’
WHEN config_device_type = 13 THEN ‘Wearable’
ELSE ‘Other’
END AS device_label