Ask HN: Which query builders (SQL) inspire you and why?

I'm looking for inspiration. The query builders I've worked with have had convoluted method-chaining to build the queries, poor or no support for CTEs or database-specific methods, their own DSLs and generally been just-useful enough to keep using but magnitudes more painful than writing SQL.

If I were to write a query builder, which should I look to for inspiration and why?