I'd like you to think for a moment about CTEs, the HAVING clause, window functions and every other funky and useful thing you can do in SQL ... Now just think, do you think that this syntax supports all those correctly?
Probably no better or worse than any other ORM written in a more traditional language. Worst comes to worst, you can always escape to plain SQL.