PostgreSQL Queries on JSONB Fields with Ecto
The Promotions team at theScore is responsible for enabling dynamic marketing campaigns throughout thescore.bet application. To determine which users are eligible for a campaign, we need to execute dynamic queries in Elixir's Ecto library against data stored in a PostgreSQL JSONB-type field.