User.order(email: :desc)

Page.order("category_id ASC")
# SELECT "pages".* FROM "pages" ORDER BY category_id ASC
User.order(:name, email: :desc)
# SELECT "users".* FROM "users" ORDER BY "users"."name" ASC, "users"."email" DESC

# rails >=7
result = user.user_books.in_order_of(:status, %w[to_read currently_reading read])
=> #<ActiveRecord::Relation [#<UserBook id: 3, user_id: 1, status: "to_read">, #<UserBook id: 4, user_id: 1, status: "to_read">, #<UserBook id: 5, user_id: 1, status: "currently_reading">, #<UserBook id: 6, user_id: 1, status: "read">]>