Find all fields that have data with leading or trailing spaces in Rails

problematic_fields.rb

# Given several models with string or text fields
# where data entered those fields often contain
# leading or trailing spaces, find those fields.

Rails.application.eager_load!
problematic = {}
ApplicationRecord.descendants.each do |model|
  model_key = model.to_s.downcase.to_sym
  problematic.merge!({ model_key => [] })
  model.attribute_names.each do |attribute|
    problem = model.where("LEFT(#{attribute}, 1) = ' ' OR RIGHT(#{attribute}, 1) = ' '").any?
    problematic[model_key] << attribute if problem
  end rescue next
end
problematic.reject! { |k,v| v.empty? }

# Result:
# {
#   model: ["field_1", "field_2"]
# }