Yes, but that's basically sugar for generating raw queries

Yes, this is the main reason why they exist in the first place.

From my perhaps minimal experience with query builders they're there to make sql queries graphical and therefore presumably easier. IME they don't do a good job of that. If you an handle the semantics of SQL you can put a bit more work in and learn the syntax. It'll pay for itself rapidly.