doc: show the use of string expressions in the SQLTagStore example

schliepa · RafaelGSS · commit bebb4731b182 · 2026-01-13T10:04:35.000-03:00
If a users attempts to escape strings with quotes in SQLTagStore template strings (`'${expression}'`), as is usually required for SQL query strings, the queries would fail. This change shows an example on the correct use (`${expression}`). PR-URL: #60873 Reviewed-By: René <contact.9a5d6388@renegade334.me.uk> Reviewed-By: Colin Ihrig <cjihrig@gmail.com>
diff --git a/doc/api/sqlite.md b/doc/api/sqlite.md
@@ -550,8 +550,8 @@ sql.run`INSERT INTO users VALUES (1, 'Alice')`;
 sql.run`INSERT INTO users VALUES (2, 'Bob')`;
 
 // Using the 'get' method to retrieve a single row.
-const id = 1;
-const user = sql.get`SELECT * FROM users WHERE id = ${id}`;
+const name = 'Alice';
+const user = sql.get`SELECT * FROM users WHERE name = ${name}`;
 console.log(user); // { id: 1, name: 'Alice' }
 
 // Using the 'all' method to retrieve all rows.
@@ -577,8 +577,8 @@ sql.run`INSERT INTO users VALUES (1, 'Alice')`;
 sql.run`INSERT INTO users VALUES (2, 'Bob')`;
 
 // Using the 'get' method to retrieve a single row.
-const id = 1;
-const user = sql.get`SELECT * FROM users WHERE id = ${id}`;
+const name = 'Alice';
+const user = sql.get`SELECT * FROM users WHERE name = ${name}`;
 console.log(user); // { id: 1, name: 'Alice' }
 
 // Using the 'all' method to retrieve all rows.
