title: SQLAlchemy ORM ClauseElement select column 1, where column 2 in table 1
body: <p>Very new to Flask, SQLAlchemy ORM and ClauseElement usage. Still not sure how to ask the question....</p>
  
  <p>I'm trying to figure out what the equivalent would be for SQLAlchemy ORM? I've been through the SQLAlchemy documentation which is daunting if you're new to it and just simply not sure which SQLAlchemy implement to use.</p>
  
  <pre><code>test_strings = ["red", "green", "blue"]
  for strings = test_strings:
  
      select COLUMN2 from TABLE1 where COLUMN4 = strings;
  </code></pre>
  
  <p>I'd like to achieve the result of having a list of items in COLUMN2 FOR EACH item in COLUMN4. So it would look something like this visually.</p>
  
  <pre><code>blue: Plumbs
  red: Pairs, red-grapes, Strawberries
  green: Mangos, watermellons, green-grapes 
  </code></pre>