"select column1 from table1 
where name = '#{person_name}'"

# becomes

Select[:column1].from[:table1].where do
  name = person_name
end

1.to_sql                     #=> "1"
"foo".to_sql                 #=> "'foo'"
:column.to_sql               #=> "column"
[1, 'foo', :column].to_sql   #=> "1, 'foo', column"

"escaped_values = hash.values.collect { |value| sql_escape value }
insert into #{hash.keys.join(", ")} values #{escaped_values.join(", ")}"

# becomes

Insert.into[hash.keys.to_sql].values[hash.values.to_sql]

"select column1 from table1, table2
where table1.column1 = table2.table1_id
#{"and table1.column2 >= #{quantity}" if quantity > 0}"

# becomes

Select[:column1].from[:table1, :table2].where do
  table1.column1 = table2.table1_id
  table1.column2 >= quantity if quantity > 0
end

Select[:column1].from[table1].where do
  table1.column1 = table2.column1
end  #=> Raises an error stating that table2 does not exist in the from clause.

class ActiveRecord::Base
  alias original_execute execute
  def execute(arg, &block)
    original_execute block.call.to_sql(connection)
  end
end