Sets the columns to insert.

The {@link values} method sets both the columns and the values and this method is not needed. But if you are using the {@link expression} method, you can use this method to set the columns to insert.

Examples

db.insertInto('person')
  .columns(['first_name'])
  .expression((eb) => eb.selectFrom('pet').select('pet.name'))

The generated SQL (PostgreSQL):

insert into "person" ("first_name")
select "pet"."name" from "pet"