Waddler SQL identifier

This guide assumes familiarity with:

Quick start with Waddler - read here
Waddler SQL template - read here

sql.identifier lets you conveniently pass identifiers to SQL query with automatic escaping:

await sql`select * from ${sql.identifier("users")}`;
await sql`select ${sql.identifier("id")} from ${sql.identifier("users")}`;
await sql`select ${sql.identifier(["id", "name", "email"])} from ${sql.identifier("users")}`;

select * from `users`;
select `id` from `users`;
select `id`, `name`, `email` from `users`;

You can explicitely provide schema, table and column to the query:

tables

columns

columns and tables

const users = sql.identifier({ schema: "public", table: "users" });
await sql`select * from ${users}`;

select * from `public`.`users`;

const id = sql.identifier({ schema: "public", table: "users", column: "id" });
await sql`select ${id} from "users"`;

const multipleColumns = sql.identifier([
	{ schema: "public", table: "users", column: "id" }
	{ schema: "public", table: "users", column: "name" }
	{ schema: "public", table: "users", column: "email" }
]);
await sql`select ${multipleColumns} from "users"`;

select `public`.`users`.`id` from `users`;
select `public`.`users`.`id`, `public`.`users`.`name`, `public`.`users`.`email` from `users`;

const table = sql.identifier({ schema: "public", table: "users" })
const columns = sql.identifier([
	{ ...table, column: "id" }
	{ ...table, column: "name" }
	{ ...table, column: "email" }
]);
await sql`select ${columns} from ${table}`;

select `public`.`users`.`id`, `public`.`users`.`name`, `public`.`users`.`email` from `public`.`users`;

SQL identifier has support for as:

const table = sql.identifier({ schema: "public", table: "users", as: "u" })
const id = sql.identifier({ table: "u", column: "id", as: "userId" });
await sql`select ${columns} from ${table}`;

select `u`.`id` as `userId` from `public`.`users` `u`;