SQL raw

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.raw lets you dynamically build SQL by embedding raw strings:

IMPORTANT

Beware sql.raw does not get escaped and going to be embedded into SQL statement as is

await sql`select * from [users] ${sql.raw("where id = 10")}`

select * from [users] where id = 10;

const listUsers = async (filter: string | undefined) => {
  const whereClause = filter ? sql.raw(` where ${filter}`) : sql.raw("");
  return sql`select * from [users]${whereClause}`;
}

await listUsers("`id` = 10");
await listUsers("`name` = 'Dan'");
await listUsers();

select * from [users] where `id` = 10;
select * from [users] where `name` = 'Dan';
select * from [users];