title: SQLAlchemy Core: order by desc
body: <p>What is the proper way to execute a select statement with an "ORDER BY foo DESC" in SQLAlchemy core? (<strong>core, not ORM!</strong>) </p>
  
  <p>I'm currently including the direction in the <code>order_by</code> directly:</p>
  
  <pre><code>mytable.select(order_by='name DESC')
  </code></pre>
  
  <p>...it works (although I don't like it since it's a little bit "hackish"), but SQLAlchemy gives me the following warning:</p>
  
  <blockquote>
    <p>SAWarning: Can't resolve label reference 'name DESC'; converting to
    text() (this warning may be suppressed after 10 occurrences)<br>
    util.ellipses_string(element.element))</p>
  </blockquote>
  
  <p>(I didn't find anything about in <a href="http://docs.sqlalchemy.org/en/latest/core/selectable.html#sqlalchemy.sql.expression.select" rel="noreferrer">the doc</a>)</p>