Easy to use, fast execution of queries with no need complex SQL statements (even if there are many).
I used it in one project as an alternative way from Golang's sql package that has some limitations when dealing big data sets like tables having millions or billions records - this framework solves them all without any problem at least up till now! You don't have much control over your database but you can still get what u want by using JOINs between two entities so far i didn´t found anything which is not good about xorms performance speed wise compared other frameworks outthere such us Dapper-dotnet/NHibernate etc.. But maybe because my application was simple only few joins were needed sometimes just 1 query solved most problems we had around relationships handling specially those involving One To Many relationships where NHibbern.