Fix QueryMethods#in_order_of for non-integer columns in MySQL

[fatkodima]

CustomerOrder.in_order_of(:order_status, ['Completed', 'Cancelled', 'In Transit', 'Pending'])
=> (Object doesn't support #inspect)

Debugging the problem further revealed that it was throwing an error while constructing the SQL.

#<Arel::Visitors::UnsupportedVisitError: Unsupported argument type: String. Construct an Arel node instead.> rescued during inspection

The problem was discovered in this blog post.

[yahonda]

Backported to 7-0-stable branch via c99a9aa

[r7kamura]

I wasn't aware of this because it wasn't in CHANGELOG, but I see this change is coming in Rails 7.0.4.

By the way, as a workaround in Rails 7.0.3.1, I had code that quoted on my application side, and I have confirmed that there is no problem with double quoting in Rails 7.0.4 with MySQ. So it's easy to migration from Rails 7.0.3.1 to 7.0.4 about that.
Nice fix 👍

$ bin/rails c -e test
Loading test environment (Rails 7.0.4)
irb(main):001:0> User.in_order_of(:name, %w[a b])
  User Load (0.3ms)  SELECT `users`.* FROM `users` WHERE `users`.`name` IN ('a', 'b') ORDER BY FIELD(`users`.`name`, 'b', 'a') DESC
=> []
irb(main):002:0> User.in_order_of(:name, %w[a b].map {|value| Arel::Nodes.build_quoted(value) })
  User Load (0.4ms)  SELECT `users`.* FROM `users` WHERE `users`.`name` IN ('a', 'b') ORDER BY FIELD(`users`.`name`, 'b', 'a') DESC
=> []