René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Invalid name generation when using python reserved keywords","articleBody":"Given the following SQL schema:\n\n```sql\nCREATE TABLE authors (\n          id    BIGSERIAL PRIMARY KEY,\n          class text      NOT NULL\n);\n```\n\nsqlc will generate the following python code :\n\n```python\nclass Author(pydantic.BaseModel):\n    id: int\n    class: str\n```\n\nThis is not a valid python code :\n\n```\n\u003e\u003e\u003e import pydantic\n... \n... \n... class Author(pydantic.BaseModel):\n...     id: int\n...     class: str\n... \n  File \"\u003cpython-input-0\u003e\", line 6\n    class: str\n         ^\nSyntaxError: invalid syntax\n```\n\nThis is due to `class` to be a reserved python keyword.\nNote that it will also fails if you use `if`, `not`, `in`, etc...\n\nI have generated an example on my fork: https://github.com/Escape-Technologies/sqlc-gen-python/tree/19e8d56813a83664bc19c12a3121e84e8bc7af66/internal/endtoend/testdata/emit_pydantic_models_with_fields","author":{"url":"https://github.com/QuentinN42","@type":"Person","name":"QuentinN42"},"datePublished":"2025-07-25T13:38:10.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/88/sqlc-gen-python/issues/88"}