Ecto 3.0 Query Improvements Overview

This article by José Valim provides an introduction to the improvements made in Ecto 3.0, specifically in the query API. Key improvements include better join composition through named bindings, which simplifies the process of constructing complex queries by reducing the reliance on positional bindings. The article also discusses new functionalities such as database prefixes and index hints. These enhancements allow developers to write more flexible and optimized queries. For instance, named bindings improve readability and maintainability in complex queries, while database prefixes and hints ensure better support for multi-tenant applications and query optimization. Additional changes include support for tuples in 'where' and 'having' clauses, arithmetic operators, and invoking database functions via fragments.