René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Args in sqlite ORDER BY not respected","articleBody":"### Version\n\n1.27.0\n\n### What happened?\n\nSimilarly to https://github.com/sqlc-dev/sqlc/issues/3113\nThe postgres generator supports variables in the ORDER BY, but sqlite does not.\n\n```sql\nCREATE TABLE authors (\n  id int PRIMARY KEY\n);\n```\n```sql\n-- name: GetAuthor :one\nSELECT * FROM authors\nWHERE id = @id\nORDER BY @order_by;\n```\n\n```\nconst getAuthor = `-- name: GetAuthor :one\nSELECT id FROM authors\nWHERE id = ?1\nORDER BY @order_by\n`\n\nfunc (q *Queries) GetAuthor(ctx context.Context, id int64) (int64, error) {\n\trow := q.db.QueryRowContext(ctx, getAuthor, id)\n\terr := row.Scan(\u0026id)\n\treturn id, err\n}\n```\nPlayground link is to 1.25.0, but this is happening locally on 1.27.0 as well. Changing only the engine value to `postgresql` results in the expected output for postgresql. But the same is not reflected in sqlite.\n\n\n### Relevant log output\n\n```shell\n\n```\n\n### Database schema\n\n```sql\nCREATE TABLE authors (\n  id int PRIMARY KEY\n);\n```\n\n### SQL queries\n\n```sql\n-- name: GetAuthor :one\nSELECT * FROM authors\nWHERE id = @id\nORDER BY @order_by;\n```\n\n### Configuration\n\n```yaml\n{\n  \"version\": \"2\",\n  \"sql\": [{\n    \"schema\": \"schema.sql\",\n    \"queries\": \"query.sql\",\n    \"engine\": \"sqlite\",\n    \"gen\": {\n      \"go\": {\n        \"out\": \"db\"\n      }\n    }\n  }]\n}\n```\n\n### Playground URL\n\nhttps://play.sqlc.dev/p/a0947e011d5ec187db7c502d1044c9eb10d6a2f9f5c6d44f166b23a2fa6c5f07\n\n### What operating system are you using?\n\nmacOS\n\n### What database engines are you using?\n\nSQLite\n\n### What type of code are you generating?\n\nGo","author":{"url":"https://github.com/bmpender","@type":"Person","name":"bmpender"},"datePublished":"2025-01-14T21:57:23.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/3788/sqlc/issues/3788"}