ent

> Ent heavily uses joins I’m specifically talking about this: https://github.com/ent/ent/issues/977. Devs assume that the `With` methods are adding join clauses but that is not typically the case. > does support multi field indices Composite primary keys are useful for reasons other than unique constraints and query speed. For example, CockroachDB uses the primary key to partition rows. Also, at scale, an extra multi-column index in addition to the primary key when the primary key alone could have sufficed can be a meaningful performance degradation. > not a Graph DB under the hood No it is not, but because it has a graph ‘mindset’ and does support Gremlin, traditional SQL folks expecting a lightweight ORM (such as Drizzle in the JS world) may not have a good time.

The ent orm for golang actually does some useful work for you. https://github.com/ent/ent

For anyone interested, it looks like there's an open-source version (close, at least) to Ent at https://github.com/ent/ent.

All of that is already built via libraries. Talking about facebook, they released an ORM a a while ago[1] and it has support for all the things you mention. [1] https://github.com/ent/ent