René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"DEFAULT VALUES doesn't work on sqlite","articleBody":"### Version\n\n1.29.0\n\n### What happened?\n\nI had a similar issue as https://github.com/sqlc-dev/sqlc/issues/3781 trying to insert `DEFAULT VALUES RETURNING id` but getting the same failure as in that issue.\n\nTo simplify and try to work around it, I removed the `RETURNING` clause and changed it to `:exec`, but still got a similar error.\n\n### Relevant log output\n\n```shell\nline 8:22 no viable alternative at input 'workspace default'\n# package \ndb/queries/auth.sql:1:1: no viable alternative at input 'workspace default'\n```\n\n### Database schema\n\n```sql\ncreate table workspace(\n\tid integer primary key autoincrement\n);\n\ncreate table user(\n\tid integer primary key autoincrement,\n\tworkspace_id integer not null references workspace(id),\n\temail text not null,\n\tpasshash text\n);\ncreate unique index user_by_email on user(email);\n```\n\n### SQL queries\n\n```sql\n-- name: InsertWorkspace :exec\ninsert into workspace default values;\n```\n\n### Configuration\n\n```yaml\nversion: \"2\"\nsql:\n- schema: db/migrations\n  queries: db/queries\n  engine: sqlite\n  gen:\n    go:\n      out: db\n```\n\n### Playground URL\n\n_No response_\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/teepark","@type":"Person","name":"teepark"},"datePublished":"2025-06-21T16:01:41.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/3998/sqlc/issues/3998"}