Doctrine QueryBuilder Methods Cheat Sheet

I've put together this quick QueryBuilder cheat sheet so you don't have to dig through Doctrine docs or source code every time you need a method reference. Contents Overview: SELECT : Field selection and DISTINCT options; FROM & JOI N: Table setup and join types ( INNER , LEFT , RIGHT ); WHERE/HAVING : Conditions with AND / OR logic; GROUP/ORDER : Grouping, sorting with reset controls; CRUD : INSERT , UPDATE , DELETE operations; Advanced : UNION (DBAL 4.x), CTE, LIMIT / OFFSET , caching. 1. SELECT select(string ...$expressions) — Defines SELECT fields, overwriting any previous selection. // SELECT u.id, u.name, u.email FROM ... $qb -> select ( 'u.id' , 'u.name' , 'u.email' ); addSelect(string $expression, string ...$expressions) — Appends fields to existing SELECT clause. // SELECT u.id, p.title, p.content FROM ... $qb -> select ( 'u.id' ) -> addSelect ( 'p.title' , 'p.content' ); distinct(bool $distinct = true) — Adds/removes DISTINCT to eliminate duplicate rows. // SELECT DISTINCT u.