René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Support for overriding types","articleBody":"It would be really helpful to have the [override functionality available in the go version of sqlc](https://docs.sqlc.dev/en/stable/howto/overrides.html#overriding-types). In combination with the existing pydantic functionality, this would be very useful.\n\ne.g., currently [`JSONB` columns are returned with `Any`](https://github.com/sqlc-dev/sqlc-gen-python/blob/53fa0b2e3d10c4201f7a5a344d00a560330da3bb/internal/postgresql_type.go#L22-L23) type. I would like to be able to override this behaviour on a per-column basis. This would be useful not only for \"Any\" types, but also for types where a different primitive is desired (e.g. a 3rd party UUID instead of the builtin, like the [go example](https://docs.sqlc.dev/en/stable/howto/overrides.html#overriding-types))\n\n## Given this schema\n\n```sql\n-- schema.sql\nCREATE TABLE some_table (\n    id SERIAL NOT NULL,\n    payload JSONB NOT NULL\n);\n```\n\n## Current output of `sqlc generate` (uses Any for payload column)\n\n```python\n# db/models.py\n# Code generated by sqlc. DO NOT EDIT.\n# versions:\n#   sqlc v1.28.0\nimport pydantic\nfrom typing import Any\n\n\nclass SomeTable(pydantic.BaseModel):\n    id: int\n    payload: Any\n```\n\n## Desired output (uses custom type for payload column)\n\n```python\n# db/models.py\n# Code generated by sqlc. DO NOT EDIT.\n# versions:\n#   sqlc v1.28.0\nimport pydantic\nimport my_lib.models\n\n\nclass SomeTable(pydantic.BaseModel):\n    id: int\n    payload: my_lib.models.Payload\n```\n\n## How it could work\n\nI would imagine something in the config like:\n\n```yaml\nversion: \"2\"\nplugins:\n  - name: py\n    wasm:\n      url: https://downloads.sqlc.dev/plugin/sqlc-gen-python_1.3.0.wasm\n      sha256: fbedae96b5ecae2380a70fb5b925fd4bff58a6cfb1f3140375d098fbab7b3a3c\nsql:\n  - schema: \"./schemq.sql\"\n    queries: \"./query\"\n    engine: postgresql\n    codegen:\n      - out: ./packages/core/src/core/db\n        plugin: py\n        options:\n          package: core.db\n          emit_pydantic_models: true\n          overrides:  # similar to the go overrides\n            - column: \"some_table.payload\"\n              py_import: \"my_lib.models\"\n              py_type: \"Payload\"\n```","author":{"url":"https://github.com/oliverlambson","@type":"Person","name":"oliverlambson"},"datePublished":"2025-03-11T21:58:47.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":3},"url":"https://github.com/82/sqlc-gen-python/issues/82"}