• limit
• fields
• where
• orWhere
• orderBy
• groupBy
• having
• orHaving
• join
• joinWhere
• joinOrWhere
• union
• lockInShareMode
• selectForUpdate
• setLockTableMode
• lockTable
• unlockTable
• setQueryOption
• setPrefix
• withTotalCount
• replace
• onDuplicate