Stubgen creating functions with signatures that will never be matched

[Lewis-E]

• yesql version: 1.0.0b4 Prerelease
• Python version: 3.11
• Operating System: macOS / https://hub.docker.com/_/python

Description

Wrote the following raw sql:

-- :name create :one
-- Create a new Recipient
INSERT INTO payments.recipient (
    stripe_account_id
) VALUES (
    NULL
)
RETURNING payments.recipient.*;

then generated stubs using yesql stubgen.

The stubs generated fine, but half of them were irrelevant and caused the following mypy linting errors:

src/payments/repository/recipient.pyi:176: error: Overloaded function signature 4 will never be matched: signature 1's parameter type(s) are the same or broader  [misc]
src/payments/repository/recipient.pyi:189: error: Overloaded function signature 5 will never be matched: signature 2's parameter type(s) are the same or broader  [misc]
src/payments/repository/recipient.pyi:203: error: Overloaded function signature 6 will never be matched: signature 3's parameter type(s) are the same or broader  [misc]

I expected stub generation to create only relevant function signatures.

Generated stubs included below:

    @typing.overload
    def create(
        self,
        /,
        *,
        instance: "Recipient | None" = None,
        connection: "yesql.types.ConnectionT" = None,
        timeout: "float" = 10,
        transaction: "bool" = True,
        rollback: "bool" = False,
        serializer: "yesql.types.SerializerT" = None,
        deserializer: "yesql.types.DeserializerT | None" = None,
    ) -> "typing.Awaitable[Recipient]":
        """Create a new Recipient"""
    @typing.overload
    def create(
        self,
        /,
        *,
        instance: "Recipient | None" = None,
        connection: "yesql.types.ConnectionT" = None,
        timeout: "float" = 10,
        transaction: "bool" = True,
        rollback: "bool" = False,
        serializer: "yesql.types.SerializerT" = None,
        deserializer: "yesql.types.DeserializerT | None" = None,
        coerce: "typing.Literal[True]",
    ) -> "typing.Awaitable[Recipient]":
        """Create a new Recipient"""
    @typing.overload
    def create(
        self,
        /,
        *,
        instance: "Recipient | None" = None,
        connection: "yesql.types.ConnectionT" = None,
        timeout: "float" = 10,
        transaction: "bool" = True,
        rollback: "bool" = False,
        serializer: "yesql.types.SerializerT" = None,
        deserializer: "yesql.types.DeserializerT | None" = None,
        coerce: "typing.Literal[False]",
    ) -> "typing.Awaitable[typing.Any]":
        """Create a new Recipient"""
    @typing.overload
    def create(
        self,
        /,
        *,
        connection: "yesql.types.ConnectionT" = None,
        timeout: "float" = 10,
        transaction: "bool" = True,
        rollback: "bool" = False,
        serializer: "yesql.types.SerializerT" = None,
        deserializer: "yesql.types.DeserializerT | None" = None,
    ) -> "typing.Awaitable[Recipient]":
        """Create a new Recipient"""
    @typing.overload
    def create(
        self,
        /,
        *,
        connection: "yesql.types.ConnectionT" = None,
        timeout: "float" = 10,
        transaction: "bool" = True,
        rollback: "bool" = False,
        serializer: "yesql.types.SerializerT" = None,
        deserializer: "yesql.types.DeserializerT | None" = None,
        coerce: "typing.Literal[True]",
    ) -> "typing.Awaitable[Recipient]":
        """Create a new Recipient"""
    @typing.overload
    def create(
        self,
        /,
        *,
        connection: "yesql.types.ConnectionT" = None,
        timeout: "float" = 10,
        transaction: "bool" = True,
        rollback: "bool" = False,
        serializer: "yesql.types.SerializerT" = None,
        deserializer: "yesql.types.DeserializerT | None" = None,
        coerce: "typing.Literal[False]",
    ) -> "typing.Awaitable[typing.Any]":
        """Create a new Recipient"""