Interface BuildInsertOptions

Options accepted by buildInsert.

interface BuildInsertOptions {
    dialect?: SQLDialect;
    orIgnore?: boolean;
    orReplace?: boolean;
    returning?: string | boolean | string[];
}

Properties

Dialect of the target shard, used to quote identifiers

1.4.0

orIgnore?: boolean

Emit INSERT OR IGNORE (SQLite) instead of a plain INSERT

orReplace?: boolean

Emit INSERT OR REPLACE (SQLite) instead of a plain INSERT

returning?: string | boolean | string[]

Append a RETURNING clause; true returns *, or pass explicit columns