programmatic LIKE in Arel

matches_any.rb

scope :search_uid, ->(*terms) {
  where(arel_attribute(:uid).matches_any(terms.map {|term| "%#{sanitize_sql_like term}%" }, nil, true))
}

simple_query.rb

scope :search, ->(params) {
  params.inject(self) do |rel, (key, value)|
    value.present? ? rel.where(arel_table[key].matches("%#{sanitize_sql_like(value)}%")) : rel
  end
}

MyModel.search(first_name: 'foo', last_name: 'bar', ...)