SQL default

This guide assumes familiarity with:

Quick start with Waddler - read here
Waddler SQL template - read here
sql.identifier - read here
sql.values - read here

sql.default lets you conveniently use SQL DEFAULT values in queries:

const values = sql.values([["Dan", sql.default], ["Alex", sql.default]])
await sql`insert into \`users\` (\`name\`, \`created_at\`) values ${values};`;

insert into `users` (`name`, `created_at`) values (?, default), (?, default);
-- params: ["Dan", "Alex"]

Complete example with sql.identifier and sql.default:

const table = sql.identifier("users")
const columns = sql.identifier(["id", "name", "age"]);
const values = sql.values([
  [sql.default, "Oleksii", 20],
  [sql.default, "Alex", 23],
]);

await sql`insert into ${table} (${columns}) values ${values};`;

insert into `users` (`id`, `name`, `age`) values (default, ?, ?), (default, ?, ?);
-- params: ["Oleksii", 20, "Alex", 23]