Waddler SQL 标识符

本指南假设您熟悉

Waddler 快速入门 - 点击此处阅读
Waddler SQL 模板 - 在此阅读

sql.identifier 允许您方便地将标识符传递给 SQL 查询，并进行自动转义

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

您可以明确地向查询提供 schema、table 和 column

表

列

列和表

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 标识符支持 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";