SQLAlchemy ORDER BY FIELD()
I am trying to sort an SQLAlchemy ORM object by a field, but with a specific order of the values (which is neither ascending or descending).  If I was doing this query on MySQL, it would look like;

    SELECT letter FROM alphabet_table WHERE letter in ('g','a','c','k')
    ORDER BY FIELDS( letter, 'g','a','c','k');

for the output:

    letter
    ------
      g
      a
      c
      k

For SQLAlchemy, I've been trying things along the lines of:

session.query(AlphabetTable).filter(AlphabetTable.letter.in_(('g','a','c','k'))).order_by(AlphabetTable.letter.in_(('g','a','c','k')))

Which doesn't work... any ideas? It's a small one-time constant list, and I could just create a table with the order and then join, but that seems like a bit too much.

SQLAlchemy ORDER BY FIELD()
===

I am trying to sort an SQLAlchemy ORM object by a field, but with a specific order of the values (which is neither ascending or descending).  If I was doing this query on MySQL, it would look like;

    SELECT letter FROM alphabet_table WHERE letter in ('g','a','c','k')
    ORDER BY FIELDS( letter, 'g','a','c','k');

for the output:

    letter
    ------
      g
      a
      c
      k

For SQLAlchemy, I've been trying things along the lines of:

session.query(AlphabetTable).filter(AlphabetTable.letter.in_(('g','a','c','k'))).order_by(AlphabetTable.letter.in_(('g','a','c','k')))

Which doesn't work... any ideas? It's a small one-time constant list, and I could just create a table with the order and then join, but that seems like a bit too much.
