attempt to refactor using arel_table

event.rb

class Event < ActiveRecord::Base

 #Existing scopes

  scope :day, lambda {|day| where("   DATE(starts_at) = '#{day}%'
    OR DATE(ends_at) = '#{day}%'
    OR DATE('#{day}') BETWEEN DATE(starts_at) AND DATE(ends_at)") }

  scope :between, lambda {|range_start, range_end| where("   DATE(starts_at) BETWEEN DATE('#{range_start}') AND DATE('#{range_end}')
    OR DATE(ends_at) BETWEEN DATE('#{range_start}') AND DATE('#{range_end}')
    OR (  DATE('#{range_start}') BETWEEN DATE(starts_at) AND DATE(ends_at)
      AND DATE('#{range_end}') BETWEEN DATE(starts_at) AND DATE(ends_at) ) ")}


  # Use Arel to compose SQL queries

  def table
    Event.arel_table
  end

  def starts(date)
    table[:starts_at].eq(date)
  end

  def ends(date)
    table[:ends_at].eq(date)
  end

  def day(date)
    where(starts(date).or(ends(date)).or("DATE('#{date}') BETWEEN DATE(starts_at) AND DATE(ends_at)"))
  end
end