title: filter enum in list of enums sqlalchemy
body: <p>I have the following enum in python:</p>
  <pre><code>class Status(enum.Enum):
      produced = 1
      consumed = 2
      success = 3
      failed = 4
  </code></pre>
  <p>and the following SQLAlchemy model</p>
  <pre><code>class Message(Base):
      __tablename__ = 'table'
      id = Column(Integer, primary_key=True)
      name = Column(String)
      status = Column(Enum(Status))
  </code></pre>
  <p>I want to filter on several statuses in query like this:</p>
  <pre><code>session.query(Message).filter(Message.status in [Status.failed, Status.success])
  </code></pre>
  <p>But no matter what I have in my DB, the results are always empty, it's probably because don't understand the type of <code>Message.status</code>.</p>
  <p>However, this does work:</p>
  <pre><code>session.query(Message).filter(Message.status == Status.failed or Message.status == Status.success)
  </code></pre>