René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Relation does not exists when name is surrounded by ` character","articleBody":"### Version\n\n1.28.0\n\n### What happened?\n\nI'm using this `sqlite3` command to export schema from the database: `sqlite3 db/data.db '.schema authors' \u003e ./db/schema.sql` and it generates an sql schema where all table and column names are surrounded with a backtick character. This schema cannot be parsed by `sqlc `.  Removing the backtick characters using command ```sed -i \"s/\\`//g\" db/schema.sql``` allows sqlc to generate the code.\n\n### Relevant log output\n\n```shell\n# package db\ndb/query.sql:6:1: relation \"authors\" does not exist\n```\n\n### Database schema\n\n```sql\nCREATE TABLE `authors` (\n  `id`   INTEGER PRIMARY KEY,\n  `name` text    NOT NULL,\n  `bio`  text\n);\n```\n\n### SQL queries\n\n```sql\n-- name: GetAuthor :one\nSELECT * FROM authors WHERE id = ? LIMIT 1;\n```\n\n### Configuration\n\n```yaml\nversion: \"2\"\nsql:\n  - engine: \"sqlite\"\n    queries: \"db/query.sql\"\n    schema: \"db/schema.sql\"\n    gen:\n      go:\n        package: \"db\"\n        out: \"db\"\n```\n\n### Playground URL\n\nhttps://play.sqlc.dev/p/5d35e2538160c53e61fe204c3a2f05fe489687ac10a8d74304a82c2d7ec95871\n\n### What operating system are you using?\n\nLinux\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/Codebreaker101","@type":"Person","name":"Codebreaker101"},"datePublished":"2025-01-21T06:15:30.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/3800/sqlc/issues/3800"}