Create

Use create for one row and createMany for bulk insertion.

create()

var created = check db.'from(User).create({
    email: "alice@example.com",
    name: "Alice"
});

create() returns a generic record {} for the inserted row.

createMany()

var rows = check db.'from(User).createMany([
    {email: "bob@example.com", name: "Bob"},
    {email: "charlie@example.com", name: "Charlie"}
]);

Notes

• The current implementation fetches inserted rows after write execution.
• Insert fetch logic assumes a primary key named id.
• PostgreSQL fallback uses lastval() when driver-generated insert IDs are unavailable.

Next step

Continue with Read.