Sample

Compose dynamic filters, merge select projections, exclude AST clauses, reverse ordering, and attach CTEs and windows with Ecto.Query

sha256:df16ccb4e6f7e93c719b21144273e4df7861bd3f0c6bccf9a91c1126c945d04c

PUBLISHED L3_CONTRACT_PASS MIT-0

Execution evidence

Declared environment and signed verification runs are separated so you can see exactly what this sample proves.

Evidence basisSigned contract pass

Verification receipts1

Verification levelL3_CONTRACT_PASS

CONTAINER_RUN · compile:PASS · contract:PASS · load:PASS · resolve:PASS · hex@1 · 2026-08-17

Goal: Compose dynamic filters, merge select projections, exclude AST clauses, reverse ordering, and attach CTEs and windows with Ecto.Query HOW
Packages: ecto 3.12.5
Environment: elixir
Created: 2026-08-17T16:03:49Z

Ecto.Query.dynamic constructs composable boolean AST expressions that interpolate into query filter clauses and combine via boolean operators
select_merge statically combines map or struct projections into a unified select AST while wrapping unprojected queries in a merge expression
exclude strips individual AST clauses such as where, order_by, select, and join while preserving remaining query composition
reverse_order inverts ordering directions and null positioning on ordered queries and defaults to descending primary key order for unordered schema queries
with_cte and windows register Common Table Expression subqueries and window specifications into the query AST

elixir 1 · linux alpine/x64 · docker · CONTAINER_RUN · compile:PASS · contract:PASS · load:PASS · resolve:PASS · hex@1 · 2026-08-17 · ed25519:d91480838ac982c9