René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"COALESCE in INSERT results in missing arguments","articleBody":"### Version\n\n1.21.0\n\n### What happened?\n\nWhen writing a query like \r\n\r\n```\r\nINSERT INTO authors (\r\n    address,\r\n    name,\r\n    bio\r\n) VALUES (\r\n    ?,\r\n    COALESCE(sqlc.narg(\"authName\"), \"\"),\r\n    COALESCE(sqlc.narg(\"authBio\"), \"\")\r\n);\r\n```\r\n\r\nOnly the ? is recognised and add as a parameter to the insert query\r\n\r\n\n\n### Relevant log output\n\n```shell\nnone - generate works\n```\n\n\n### Database schema\n\n```sql\nCREATE TABLE authors (\r\n  id   BIGINT AUTO_INCREMENT NOT NULL,\r\n  address VARCHAR(200) NOT NULL,\r\n  name VARCHAR(20) NOT NULL,\r\n  bio  LONGTEXT NOT NULL\r\n);\n```\n\n\n### SQL queries\n\n```sql\n-- name: AddAuthor :execlastid\r\nINSERT INTO authors (\r\n    address,\r\n    name,\r\n    bio\r\n) VALUES (\r\n    ?,\r\n    COALESCE(sqlc.narg(\"calName\"), \"\"),\r\n    COALESCE(sqlc.narg(\"calDescription\"), \"\")\r\n);\n```\n\n\n### Configuration\n\n```yaml\n{\r\n  \"version\": \"1\",\r\n  \"packages\": [\r\n    {\r\n      \"path\": \"db\",\r\n      \"engine\": \"mysql\",\r\n      \"schema\": \"query.sql\",\r\n      \"queries\": \"query.sql\"\r\n    }\r\n  ]\r\n}\n```\n\n\n### Playground URL\n\nhttps://play.sqlc.dev/p/8471d8c7965409b41c01510cf680b8026ae5268dc83ae2591e891c432aef0432\n\n### What operating system are you using?\n\nmacOS\n\n### What database engines are you using?\n\nMySQL\n\n### What type of code are you generating?\n\nGo","author":{"url":"https://github.com/andrei-dascalu","@type":"Person","name":"andrei-dascalu"},"datePublished":"2023-09-20T19:23:30.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":4},"url":"https://github.com/2748/sqlc/issues/2748"}