Can you elaborate on what you want? defaults will be a set of static values that will be added to the query in case they’re not present in the query result?
if that’s the case you can’t do that in a query the way you want. either you do that with cte(or case conditions inside the select statment) or you handle that in the application side after you retrieve the query data:
Why not? data present after the Repo.all is not required to be uniform for the application side to work.
with Map.merge/2 the second map(in my example the results of the query) will always have precedence over the default value.
If you need the defaults data to make the union possible, you gonna need to be explicit setting those values in the query.
Ecto queries are a DSL to build sql queries, which you can see when doing e.g. Repo.to_sql(:all, query). It therefore cannot allow you do run any actual elixir functions – the db wouldn’t know what to do with them. select specifically goes a bit astray from the plain sql in that it allows you to supply a non tabular format for data, which the data returned from the db is then mapped into. That still doesn’t allow you to use elixir functions though. For arbitrary transformations map the data manually after having loaded it from the db.