Rails/WhereEquals breaks code functionality for jsonb columns

[vccoffey]

When working with postgres jsonb columns, the build in rails where tools fail

---

Expected behavior

Given that I have a postgres jsonb column like this:

create_table "widgets", id: :serial, force: :cascade do |t|
    t.jsonb "jsonb_column_name", default: [], null: false
    ...
end

rubocop should ignore the following code
Widget.where("jsonb_column_name = ?", "[]")

Actual behavior

rubocop corrects the code to:
Widget.where(jsonb_column_name: "[]")
which returns 0 records as it is now looking for the string literal rather than an empty array

Steps to reproduce the problem

see above

RuboCop version

1.56.3 (using Parser 3.2.2.3, rubocop-ast 1.29.0, running on ruby 3.2.2) [arm64-darwin22]
  - rubocop-rails 2.21.1

[fatkodima]

Rubocop does not inspect column types, so you need to just use # rubocop:disable at this line.

[vccoffey]

For others, RoboCop does not complain about
where("jsonb_column_name = '[]'")