title: How to define Python Enum properties if MySQL ENUM values have space in their names?
body: <p>I have Python <code>Enum</code> class like this:</p>
  
  <pre><code>from enum import Enum
  class Seniority(Enum):
      Intern = "Intern"
      Junior_Engineer = "Junior Engineer"
      Medior_Engineer = "Medior Engineer"
      Senior_Engineer = "Senior Engineer"
  </code></pre>
  
  <p>In MYSQL database, seniority ENUM column has values "Intern", "Junior Engineer", "Medior Engineer", "Senior Engineer".</p>
  
  <p>The problem is that I get an error:</p>
  
  <pre><code>LookupError: "Junior Engineer" is not among the defined enum values
  </code></pre>
  
  <p>This error has occurred when I call query like:</p>
  
  <pre><code>UserProperty.query.filter_by(full_name='John Doe').first()
  </code></pre>
  
  <p><code>seniority</code> is enum property in the <code>UserProperty</code> model.</p>
  
  <pre><code>class UserProperty(db.Model):
     ...
     seniority = db.Column(db.Enum(Seniority), nullable=True)
     ...
  </code></pre>
  
  <p>For this class I've defined Schema class using <code>marshmallow</code> <code>Schema</code> and <code>EnumField</code> from <code>marshmallow_enum</code> package:</p>
  
  <pre><code>class UserPropertySchema(Schema):
      ...
      seniority = EnumField(Seniority, by_value=True)
      ...
  </code></pre>
  
  <p>What to do in this situation, because I can't define python class property name with space. How to force python to use values of defined properties instead of property names?</p>