Arel example

gistfile1.rb

# before
def self.front_page
  where(:front_page => true).select('*, coalesce(position, 999999999) AS position').order('position ASC')
end

# after
def self.front_page
  where(:front_page => true).select([
    Arel.sql('*'),
    Arel::Nodes::NamedFunction.new('COALESCE', [arel_table[:position], 999999999]).as('position')
  ]).order('position ASC')
end