There they go, making the same stupid mistakes as most other ORMs out there; by 1:1-mapping structs to tables as well as inventing their own SQL-dialect.

That is a valid point. There is no point in arriving at your own dialect of SQL to void using the standardised SQL.

A better path is to use the actual features of the programming language to provide a query interface; which can offer similar features in a type safe, well integrated fashion.