René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Wrong variable name generation with named parameter inside OFFSET() function","articleBody":"```SQL\n-- name: get_plot_lists :many\nWITH grouped_lists AS (\n    SELECT\n        l.id,\n        l.name,\n        l.created_at,\n        array_agg(p2l.cadastral_number) AS cadastral_numbers\n    FROM public.plot_lists AS l\n    LEFT JOIN public.land_plot2plot_list AS p2l ON l.id = p2l.plot_list_id\n    GROUP BY l.id, l.name\n)\nSELECT\n    gl.name,\n    gl.cadastral_numbers,\n    (SELECT COUNT(*) FROM public.plot_lists) AS total\nFROM grouped_lists gl\nORDER BY gl.created_at\nLIMIT @pagination_limit OFFSET (@page - 1) * @pagination_limit;\n```\n\nThis sql query gives next python function:\n```python\nasync def get_plot_lists(self, *, -page: Optional[Any], pagination_limit: int) -\u003e AsyncIterator[get_plot_listsRow]:\n    result = await self._conn.stream(sqlalchemy.text(GET_PLOT_LISTS), {\"p1\": -page, \"p2\": pagination_limit})\n    async for row in result:\n        yield get_plot_listsRow(\n            name=row[0],\n            cadastral_numbers=row[1],\n            total=row[2],\n        )\n```\n\n'page' arg generated with '-' as prefix.\n\n\u003e -\u003e % sqlc version\n\u003e v1.28.0\n\u003e \n\u003e plugins:\n\u003e     - name: py\n\u003e       wasm:\n\u003e           url: https://downloads.sqlc.dev/plugin/sqlc-gen-python_1.3.0.wasm\n\u003e           sha256: fbedae96b5ecae2380a70fb5b925fd4bff58a6cfb1f3140375d098fbab7b3a3c","author":{"url":"https://github.com/maxnetyaga","@type":"Person","name":"maxnetyaga"},"datePublished":"2025-06-25T16:41:41.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/86/sqlc-gen-python/issues/86"}