[malkosta]

> Ecto as the main way of interacting with the database was a miserable experience

That's very common when you don't know DBs. But DB savy developers usually claim the opposite, because the syntax is more familiar.

[zinclozenge]

> That's very common when you don't know DBs.

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.

[sph]

No one stops you from writing raw SQL with Ecto.

But good luck creating composable SQL with raw string interpolation, which Ecto excels at.

[zinclozenge]

PR reviewers stopped me from writing raw SQL.

[malkosta]

Ecto queries are much closer to DB queries, when you use the macro syntax.

But if you come from an ORM perspective and expect the same experience on Ecto, yes I agree it won't please you.