AREL syntax questions

raw_arel_composition.rb

class Manifest < ApplicationRecord
  def self.item_ids(id, keyword=nil, prefix=nil)

    cases = Arel::Table.new(:manifest_items)

    casequery = cases.where(cases[:manifest_id].eq(id))

    if keyword
      # "keywords" is an string array column in the database, so I want to generate
      # "'#{keyword}' = ANY(keywords)", essentially, with correct quoting/escaping
      selectmanager = casequery.and(Arel::Nodes::Quoted.new(keyword).eq_any(cases[:keywords]))
    end

    if prefix
      # 
      selectmanager = casequery.and(cases[:title].matches("#{prefix}%"))
    end

    query = casequery.project(cases[:item_id]).distinct.to_sql

    return query

    self.connection.execute(
      query
    ).pluck(:item_id)
  end
end