order using case

[rahmat-dev]

Can I order data like this query without using the raw method?

SELECT * FROM your_table
    ORDER BY
        CASE
            WHEN condition THEN 1
            ELSE 0
        END ASC,
        createdAt DESC;