Experiment on ordering an active record query

active_record_query_ordering.rb

require 'active_record'
ActiveRecord::Base.establish_connection adapter: 'sqlite3', database: ':memory:'

ActiveRecord::Schema.define do
  self.verbose = false
  create_table :posts do |t|
    t.string :title
    t.string :status
  end
end

Post = Class.new ActiveRecord::Base

ActiveRecord::VERSION::STRING # => "7.0.4"

Post.create!([
  { title: 'yo ho ho', status: 'draft' },
  { title: 'and a bottle of rum', status: 'published' },
])

Post.order(Arel.sql("status = 'draft' DESC, title ASC")).to_sql
# => "SELECT \"posts\".* FROM \"posts\" ORDER BY status = 'draft' DESC, title ASC"

Post.order(Arel.sql("status = 'draft'") => :desc, title: :asc).to_sql
# => "SELECT \"posts\".* FROM \"posts\" ORDER BY status = 'draft' DESC, \"posts\".\"title\" ASC"