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";