You do not need that subquery, if this is just association then:
query = from t in Thing,
join: s in assoc(s, :sub_thing),
group_by: t.id
select_merge: %{sub_thing_count: count(s.id)}
Will work as expected (DB optimisers are good enough to not fetch whole entries.
