Insert - LanceDB

Applies to: Embedded ❌, Enterprise ✅

INSERT INTO documents (id, title) VALUES (1, 'Merlin'), (2, 'Arthur')

INSERT INTO archive
SELECT * FROM documents
WHERE created_at < '2026-01-01'

INSERT ... SELECT is the form worth knowing: it moves rows between tables server-side, without a round trip through your process. Commits a new table version, so versioning and the write guarantees apply, including that the version advances even when the statement affects zero rows.

What to read next

Insert

The SDK equivalent.

Merge Insert

Upsert (matching incoming rows against existing keys) has no SQL form.