I haven't worked with many ORMs, but Django's is imo very good in tackling the lack of composability in SQL.