René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Wrong type when using sum function","articleBody":"Let's say we have `my_table.my_numeric` being of numeric type.\n\nFrom this query\n```\nSELECT my_numeric FROM my_table WHERE key = @key;\n```\n\nWe have this function generated\n```\ndef tmp(self, *, key: uuid.UUID) -\u003e Optional[decimal.Decimal]:\n```\n\nBut when a function like a sum is used\n```\nSELECT SUM(my_numeric) FROM my_table;\n```\n\nIt's typed with an int\n```\ndef tmp(self) -\u003e Optional[int]:\n```\nEven though it actually returns a Decimal\n\nOf course, explicit typing properly works\n```\nSELECT SUM(my_numeric)::numeric FROM my_table;\n```\n```\ndef tmp(self) -\u003e Optional[decimal.Decimal]:\n```\n\n","author":{"url":"https://github.com/Maveldu","@type":"Person","name":"Maveldu"},"datePublished":"2025-05-16T08:12:44.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/85/sqlc-gen-python/issues/85"}