Query Building FROM clause WHERE clause SELECT clause ORDER BY clause LIMIT clause Compound Query UNION clause Compound Query ORDER BY clause Compound Query LIMIT clause Query Misc Correlated Subqueries Derived Table Query Execution .map() .fetchAllXxx() .fetchOne() .fetchZeroOrOne() .fetchValueArray() .fetchValueXxx() .paginate() .emulatedCursor() .count() .exists()/.assertExists()