That's very common when you don't know DBs. But DB savy developers usually claim the opposite, because the syntax is more familiar.
I'm not a 20 year DBA greybeard veteran, but I'm comfortable enough to write schemas and queries by hand without any issue, and the entire time I wished I could do just that instead of using Ecto.
But good luck creating composable SQL with raw string interpolation, which Ecto excels at.
But if you come from an ORM perspective and expect the same experience on Ecto, yes I agree it won't please you.