René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"template literal style ambiguity","articleBody":"When using the template-literal-style:\r\n```\r\nconst result = await connection.sql`\r\n    SELECT * FROM artists\r\n    WHERE name LIKE \"%${filter}%\"\r\n    LIMIT ${limit}\r\n`;\r\n```\r\n\r\nthere is ambiguity about the expectation. In this case 3, I'd expect the query to work but the prepared statement requires the entire string `%myvalue%` as value.\r\nIn the case above, the query is converted into\r\n```\r\nSELECT * FROM artists\r\nWHERE name LIKE \"%?%\"\r\nLIMIT ?\r\n```\r\nwith parameters `[\"myvalue\", 10]`. \r\nSQLite instead requires parameters to be `[\"%myvalue%, 10]`.\r\n\r\n**This template literal syntax should be deprecated.**\r\n**The correct syntax to properly escape parameters without ambiguity is (case 5 below)**:\r\n```\r\nconst result = await connection.sql(`\r\n    SELECT * FROM artists\r\n    WHERE name LIKE ?\r\n    LIMIT ?\r\n`, `%${filter}%`, 10);\r\n```\r\n\r\n## Tested cases\r\n\r\n### Case 1 ✅ \r\n:warning:  parameters are not escaped\r\n```\r\nconst result = await connection.sql(`\r\n    SELECT * FROM artists\r\n    WHERE name LIKE \"%${filter}%\"\r\n    LIMIT ${limit}\r\n`);\r\n```\r\n\r\n### Case 2 ✅\r\n```\r\nfilter = `%${filter}%`\r\nconst result = await connection.sql`\r\n    SELECT * FROM artists\r\n    WHERE name LIKE ${filter}\r\n    LIMIT ${limit}\r\n`;\r\n```\r\n\r\n### Case 3 ❌\r\n```\r\nconst result = await connection.sql`\r\n    SELECT * FROM artists\r\n    WHERE name LIKE \"%${filter}%\"\r\n    LIMIT ${limit}\r\n`;\r\n```\r\n\r\n### Case 4 ✅ \r\n```\r\nconst result = await connection.sql(`\r\n    SELECT * FROM artists\r\n    WHERE name LIKE ?\r\n    LIMIT ${limit}\r\n`, `%${filter}%`);","author":{"url":"https://github.com/danielebriggi","@type":"Person","name":"danielebriggi"},"datePublished":"2025-01-02T15:41:28.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/186/sqlitecloud-js/issues/186"}