Ecto is a great library for making composable queries, but to query a JSONB field within a schema, it requires falling back to native PostgreSQL functions. Check out our story while working on features for theScore Bet

https://techblog.thescore.com/2022/06/23/embedded-schema-queries-with-ecto/