PostgreSQL 17 to 18: uuidv7, virtual generated columns, OLD and NEW in RETURNING

npm init -y >/dev/null
npm install --silent --no-audit --no-fund @electric-sql/pglite@0.5.10 >/dev/null 2>&1
cat > q.mjs <<'EOF'
import { PGlite } from "@electric-sql/pglite";
const db = new PGlite();
const show = async (sql) => console.log(JSON.stringify((await db.query(sql)).rows));
await show(`select current_setting('server_version') as version`);
// uuidv7(): time-ordered UUIDs, good for primary keys
await show(`select uuidv7() < uuidv7() as time_ordered, length(uuidv7()::text) as len`);
// generated columns are virtual unless you write STORED
await db.query(`create table items (id int primary key, price numeric, qty int,
                total numeric generated always as (price * qty))`);
await db.query(`insert into items values (1, 2.5, 4)`);
await show(`select attgenerated from pg_attribute where attrelid = 'items'::regclass and attname = 'total'`);
// RETURNING can read the old and the new row
await show(`update items set qty = 10 where id = 1 returning old.qty as old_qty, new.qty as new_qty, new.total`);
EOF
node q.mjs