title: Access array elements ANSI SQL
body: <p>I'm using Drill to query MongoDB using ANSI SQL , I have a field that contains an array of values, I want to be able to access those elements to join them with other documents .</p>
  
  <pre><code>select name from table where table.id = array.element;
  </code></pre>
  
  <p>but other than <code>FLATTEN</code> which divides them into multiple lines, I can't access the array's elements. 
  Any help please ? </p>