Single row
Insert a single row:
Multiple rows
On dialects that support it (for example PostgreSQL) you can insert multiple
Returning data
On supported dialects like PostgreSQL you need to chain returning to the query to get
Complex values
In addition to primitives, the values can also be arbitrary expressions.
Insert subquery
You can create an INSERT INTO SELECT FROM query using the expression method.