Need a way to get the primary key back from an `insert` call

[sc68cal]

Generally, it is useful to have the primary key get returned from an insert call in an ORM, so that you can insert rows into other tables and reference that newly created row in the primary table, do HTTP redirects using that primary key, etc etc etc.

Currently repo.insert return is void which is not very helpful.

Looking briefly at the PostgreSQL docs, it appears that the INSERT INTO <> VALUES <> RETURNING id seems to be the general practice for PostgreSQL

[sc68cal]

Struggling with and getting it to return a value that I can use.

    var lastval = try request.repo.executeSql("SELECT LASTVAL();", .{});

I tried doing lastval.unary(i32) but that doesn't seem to be right.

[mitteneer]

@sc68cal You can use .returning(.{.your_returned_val}). It hasn't been added to the documentation yet.

jetquery/src/jetquery/Repo.zig

Line 1424 in 6c3fa3c

.returning(.{.name})

[sc68cal]

Argh I swear that I try and dig into the code before filing an issue but of course I didn't this time

[sc68cal]

I will contribute docs to the site to documents this

[sc68cal]

Where is the database section? I don't see it under https://github.com/jetzig-framework/jetzig.dev/tree/main/src/app/views/documentation/sections