Doctrine Query Builder

setParameter($parameter, $value)

addCriteria(Criteria $criteria)

[get/set]MaxResults($maxResults)

[get/set]FirstResult($firstResult)

getQuery()

add($dqlPartName, $dqlPart, $append = false)

$dqlPartName: select, from, join, set, where, groupBy, having, orderBy

[add]select($select= null)

delete($delete = null, $alias = null)

update($update = null, $alias = null)

set($key, $value)

from($from, $alias, $indexBy = null)

[inner/left]join($join, $alias, $conditionType = null, $condition = null, $indexBy = null)

[and/or]where($where)

[add]groupBy($groupBy)

[and/or]having($having)

[add]orderBy($field, $order = null)