Playground does not work when a column is named "user"

[EwenQuim]

Version

1.27.0

What happened?

• with a column named "user" : breaks https://play.sqlc.dev/p/d9484101cc7acc23148e19ef6e07a63381d0c4be591904909a02b83b5ac7e0c8
• without this column (no other difference) : works https://play.sqlc.dev/p/863a2ec503acd2b45dfb43b7afa67c9b62fce63d07bc38669c3aebb5e8214d86

Relevant log output

sqlc generate failed.
# package 
schema.sql:4:4: syntax error at or near "user"

Database schema

CREATE TABLE IF NOT EXISTS notes (
  id text PRIMARY KEY,
  slug text NOT NULL,
  user text NOT NULL, 
  UNIQUE(slug, user)
);

SQL queries

None

Configuration

{
  "version": "2",
  "sql": [{
    "schema": "schema.sql",
    "queries": "query.sql",
    "engine": "postgresql",
    "gen": {
      "go": {
        "out": "db"
      }
    }
  }]
}

Playground URL

https://play.sqlc.dev/p/d9484101cc7acc23148e19ef6e07a63381d0c4be591904909a02b83b5ac7e0c8

What operating system are you using?

No response

What database engines are you using?

No response

What type of code are you generating?

No response

[kyleconroy]

Thanks for the report. user conflicts with a built in function for PostgreSQL, so you need to use it double quotes. Here's a working example.

https://play.sqlc.dev/p/02bbc37ca7fc34be99fb9d941f11ece21b3e642d7680f215d156845fc4de43be