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

schliepa · aduh95 · commit 6c440af39b43 · 2026-01-19T19:19:15.000+01: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
@@ -540,8 +540,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.
@@ -567,8 +567,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.
