Wow, a project describing itself as a “Next generation ORM” that… doesn’t do joins, with no way to optimise queries.

Perhaps they mean “Next generation” as in, the 1987 TV series sense. Which would still be a long time after the concept of joins…

To boldly go where the problem was solved ages ago

There's One Weird Trick™ in managing joins in this case -- create views that implement the joins and then just treat it as yet another table. Bonus feature is creating a consistent way of working with that relation using native DB tools. ;-)

that works great till your database gets big. Then you will watch your memory use skyrocket to perform joins into that view and it will F@#$@# your shit up. eventually it will take so much time to construct your view table that you'll tiemout your connection pool.

to be clear, dont' use views in production queries. you WILL regret it.

source: made this mistake.

Really wow. Such a basic feature should be available in beta version