How to do case statement in order

[fcennecf]

Hello.
Could someone help me with that SQL in gino?
Example:

SELECT *
FROM Record
ORDER BY
    CASE WHEN name = 'required' THEN 0 ELSE 1 END
LIMIT 3

This variant doesn't work.

class Record(db.Model):
   name:  db.Column(db.Text())

Record.query.order_by(
    db.func.case([Record.name == name, 0], else_=1),
).gino.first()

[Pentusha]

I ran into a similar problem once and solved it with additional cast from string to integer:

from sqlalchemy import case, cast
from sqlalchemy.dialects.postgresql import INTEGER

cast(
    case([
        (Record.name == name, '0'),
    ], else_='1'),
    type_=INTEGER,
)

[fcennecf]

Thanks.