SQLAlchemy Core: order by desc
<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>