Vex · Query DSL

Writes: insert, update, delete, upsert

A write is a DSL document with an op: insert, insertEach, update, delete or upsert. executeWrites compiles it to one SQL statement and passes it to a client. The client on this page records the statement and executes nothing.

Write

{
  op: 'insert',
  table: 'bookings',
  values: {
    id: { $context: 'id' },
    show_night: { $context: 'night' },
    member_id: { $context: 'member' },
    seats: { $context: 'seats' },
  },
}

Context

{
  id: 'B-2046',
  night: '2026-10-23',
  member: 'alan',
  seats: 2,
}

SQL

INSERT INTO bookings (id, show_night, member_id, seats)
VALUES ($1, $2, $3, $4)
RETURNING *

Parameter values

['B-2046', '2026-10-23', 'alan', 2]

Output matches the expected value

Runs in this page on the installed package. The input and the expected output are defined by the example.