.let()

Assigns a value as a parameter for this connection.

Method Syntax
async db.let(key: string, val: any)

Arguments

Example Usage

// Assign the variable on the connection
await db.let('name', {
	first: 'Tobie',
	last: 'Morgan Hitchcock',
});

// Use the variable in a subsequent query
await db.query('CREATE person SET name = $name');

// Use the variable in a subsequent query
await db.query('SELECT * FROM person WHERE name.first = $name.first');

You can remove the variable from the connection using the unset() method.