title: SELECT Specific Value from map
body: <p>I am trying to create a WIDE Column Table, 20,000+ columns</p>
  
  <p>Initially I was thinking I would use:</p>
  
  <pre><code>CREATE TABLE details (
     key TEXT,
     detail map&lt;TEXT, TEXT&gt;
     PRIMARY KEY (KEY)
    );
  </code></pre>
  
  <p>Inserting into this table works fine</p>
  
  <pre><code>UPDATE details SET detail = detail + { 'col1': '12'} where key='123' ;
  UPDATE details SET detail = detail + { 'col20000': 'ABCD'} where key='123' ;
  </code></pre>
  
  <p>However, I would like to read an individual detail:</p>
  
  <pre><code>   select detail[col1] where key='123'
  </code></pre>
  
  <p>when executing this query I get the following error:</p>
  
  <pre><code> no viable alternative at input '['
  </code></pre>
  
  <p>Will this work, or do I need a different approach?</p>