Querying Postgres JSONB arrays using Active Record in Raiils

application_record.rb

class ApplicationRecord < ActiveRecord::Base
  extend JsonQuerying
  self.abstract_class = true
end

jsonb_querying.rb

# include the following module in ApplicationRecord or any any model you wish use it in
module JsonQuerying
  # method for checking if given array equals the value in DB.
  def array_eq(column_name, *args)
    array_contains(column_name, *args)
  end
  # method for checking if array contains all the values.
  def array_contains(column_name, *args)
    args = args.map(&:to_s) unless [Integer, Float].include?(args[0].class)
    where(["#{table_name}.#{column_name} ?& ARRAY[:vals]", { vals: args }])
  end
  # method for checking if array contains any of the values.
  def array_contains_any(column_name, *args)
    args = args.map(&:to_s) unless [Integer, Float].include?(args[0].class)
    where(["#{table_name}.#{column_name} ?| ARRAY[:vals]", { vals: args }])
  end

some_model.rb

class SomeModel < ApplicationRecord
end

usage.rb

# for finding records containing any of the elements in array
SomeModel.array_contains_any(:column_a, ['x', 'y', 'z'])
# for finding records containing any of the all the elements in array
SomeModel.array_contains(:column_a, ['x', 'y', 'z'])
# or
SomeModel.array_eq(:column_a, ['x', 'y', 'z'])