Ecto and CockroachDB issue: (CaseClauseError) no case clause matching

Actually, you found something else. Have a look at hints argument. It is placed right after declaration of an alias.
This keyword is used by Tds adapter Ecto.Adapters.Tds — Ecto SQL v3.14.0

and looks like this is what is needed:

from u in User, hints: ["AS OF SYSTEM TIME '-5m'"]

but if you call Repo.all, then you’ll see the error

** (Ecto.QueryError) table hints are not supported by PostgreSQL

and here patching the adapter may help.