gistfile1.rb

# limit/offset using Enumerable#slice

collection[0, 20]  # LIMIT 0, 20
collection[0..20]  # LIMIT 0, 20


# ordering using Enumerable#sort_by (will not require ParseTree)

collection.sort_by { |o| o.name }               # ORDER BY name
collection.sort_by { |o| -o.name }              # ORDER BY name DESC
collection.sort_by { |o| [ -o.name, o.age ]  }  # ORDER BY name DESC, age