I would argue that Entity Framework Core (#csharp#dotnet) has the same pros and cons like any other ORM no matter what language.
Those ORMs looking appealing at first, but once you start doing more advanced things, they start to get in your way and getting slow.
Instead I use ADO.NET (Npgsql), Dapper and Fluent Migrator. Having the ability to write your queries in plain SQL and using Dapper for object mapping matches they way I do it in #php
