Support jsonb predecates

[miry]

PostgreSQL offers various methods to work with jsonb fields efficiently.

Here’s a pseudocode example illustrating a model and how to filter using a jsonb field:

class TestUserProfile < Marten::Model
  field :id, :big_int, primary_key: true, auto: true
  field :user, :one_to_one, to: TestUser, related: :profile
  field :bio, :text, blank: true, null: true
  field :groups, :jsonb # This represents an array of strings, e.g., ["admin", "user", "manager"]
end

# Filtering profiles where groups include an intersection with ["admin", "ukraine"]
TestUserProfile.filter(groups__intersection: ["admin", "ukraine"]) # -> 'WHERE groups ?| array["admin", "ukraine"]'