René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Type TAllowedParameterValue more completely","articleBody":"[Currently](https://github.com/databricks/databricks-sql-python/blob/fd81c5a6e1b7b46e865738e7462bce85f4ffb5b4/src/databricks/sql/parameters/native.py#L57), the type definition of TAllowedParameterValue is\n\n```py\nTAllowedParameterValue = Union[\n    str,\n    int,\n    float,\n    datetime.datetime,\n    datetime.date,\n    bool,\n    decimal.Decimal,\n    None,\n    list,\n    dict,\n    tuple,\n]\n```\n\nlist, dict, and tuple are incomplete types. That means when I try to write a wrapper function around cursor.execute using that type as the type of a parameter sql_params_dict, pyright strict yells at me `Type of parameter \"sql_params_dict\" is partially unknown`.\n\nI think this can easily be fixed. My guess is, this could simply be a recursive type definition, and those last three lines could be changed to\n\n```py\n    list[TAllowedParameterValue],\n    dict[TAllowedParameterValue, TAllowedParameterValue],\n    tuple[TAllowedParameterValue, ...]\n]\n```\n\nHowever, there may be more or fewer restrictions on those types. I didn't look into it very hard.","author":{"url":"https://github.com/wyattscarpenter","@type":"Person","name":"wyattscarpenter"},"datePublished":"2025-08-08T11:43:44.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/669/databricks-sql-python/issues/669"}