Insert subquery

You can create an INSERT INTO SELECT FROM query using the expression method. This API doesn't follow our WYSIWYG principles and might be a bit difficult to remember. The reasons for this design stem from implementation difficulties.

More examples

The API documentation is packed with examples. The API docs are hosted here but you can access the same documentation by hovering over functions/methods/classes in your IDE. The examples are always just one hover away!

For example, check out these sections:

• values method
• onConflict method
• returning method
• insertInto method