title: BigQuery SQL User Agent Detecting
body: <p>How is it possible to extract information about
  Device Type
  Browser,
  OS and etc.
  from the user agent string as :</p>
  <pre><code>Mozilla/5.0 (Linux; Android 10; SM-A307G Build/QP1A.190711.020; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/87.0.4280.141 Mobile Safari/537.36 Instagram 170.2.0.30.474 Android (29/10; 280dpi; 720x1423; samsung; SM-A307G; a30s; exynos7904; es_US; 267925733)
  
  </code></pre>
  <p>Thanks</p>