gistfile1.rb

# AR & Sequel
User.where(name: "Tom")
User.where("name = :name", name: "Tom")
User.where("name = ? OR email = ?", "Tom", "[email protected]")
User.where("users.name = ?", "Tom")

# AR-only
User.where(users: { name: "Tom" })
# Sequel-only
User.where(users__name: "Tom")
User.where(Sequel.lit('users.name') => "Tom")

# Sequel alternative option for "name = ? OR email = ?"
User.where(Sequel.expr(name: "Tom") | Sequel.expr(email: "[email protected]"))
# Sequel alternative option for "name = ? OR email != ?"
User.where(Sequel.expr(name: "Tom") | Sequel.~(email: "[email protected]"))

# AR-only
User.select("SUM(id)").first
# Sequel-only
User.select(Sequel.function(:sum, :id)).first
User.select(Sequel.lit("SUM(id)")).first

# AR-only (4.x)
User.where.not(name: "Tom")
# Sequel-only
User.exclude(name: "Tom")