Building queries
Select columns, add conditions, join tables, group, order, and page a query.
Expressions
When a string is quoted as a name, when it is raw SQL, and how aliases and bindings work.
Writing data
Insert, update, and delete rows, and the clauses a mutation refuses.
Grammars
How each database compiles the same query, and which clauses it refuses.