René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"pgx CopyFrom codegen uses parameter names instead of column names when using named parameters","articleBody":"### Version\n\n1.22.0\n\n### What happened?\n\nWhen using named parameters in your insert statement (`@param_name` or `sqlc.arg(param_name)`) the parameter name is used in the pgx CopyFrom method instead of the column name.\r\n\r\nIn the playground example below, the copyfrom codegen is:\r\n```go\r\nfunc (q *Queries) StageUserData(ctx context.Context, arg []StageUserDataParams) (int64, error) {\r\n\treturn q.db.CopyFrom(ctx, []string{\"user_data\"}, []string{\"id_parameter\", \"user_parameter\"}, \u0026iteratorForStageUserData{rows: arg})\r\n}\r\n```\r\n\r\nbut it should be\r\n```go\r\nfunc (q *Queries) StageUserData(ctx context.Context, arg []StageUserDataParams) (int64, error) {\r\n\treturn q.db.CopyFrom(ctx, []string{\"user_data\"}, []string{\"id\", \"user\"}, \u0026iteratorForStageUserData{rows: arg})\r\n}\r\n```\n\n### Relevant log output\n\n_No response_\n\n### Database schema\n\n```sql\ncreate table \"user_data\" (\r\n\t\"id\" varchar not null,\r\n\t\"user\" varchar not null,\r\n\tprimary key (\"id\")\r\n);\n```\n\n\n### SQL queries\n\n```sql\n-- name: StageUserData :copyfrom\r\ninsert into \"user_data\" (\"id\", \"user\")\r\nvalues (sqlc.arg(id_parameter), sqlc.arg(user_parameter));\n```\n\n\n### Configuration\n\n```yaml\n{\r\n  \"version\": \"2\",\r\n  \"sql\": [\r\n    {\r\n      \"engine\": \"postgresql\",\r\n      \"schema\": \"query.sql\",\r\n      \"queries\": \"query.sql\",\r\n      \"gen\": {\r\n        \"go\": {\r\n          \"package\": \"models\",\r\n          \"sql_package\": \"pgx/v5\",\r\n          \"out\": \"models\"\r\n        }\r\n      }\r\n    }\r\n  ]\r\n}\n```\n\n\n### Playground URL\n\nhttps://play.sqlc.dev/p/5e51915801b5b50a2d8836be41b4cc0503b5ce04e7c7a1e9efa6a12d719c7589\n\n### What operating system are you using?\n\nmacOS\n\n### What database engines are you using?\n\nPostgreSQL\n\n### What type of code are you generating?\n\nGo","author":{"url":"https://github.com/sgtsquiggs","@type":"Person","name":"sgtsquiggs"},"datePublished":"2023-10-11T18:42:26.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/2833/sqlc/issues/2833"}