:execlastid - Implementation
Implemented via a RETURNING clause, allowing the INSERT command to return the newly created id.
Only integer data type is supported as id for this annotation.
INSERT INTO tab1 (field1, field2) VALUES ('a', 1) RETURNING id_field;:copyfrom - Implementation
Implemented via a multi `VALUES` clause, like this:INSERT INTO tab1 (field1, field2) VALUES
('a', 1),
('b', 2),
('c', 3);Supported Data Types
| DB Type | Supported? |
|---|---|
| integer | ✅ |
| real | ✅ |
| text | ✅ |
| blob | ✅ |