Optimizing MySQL queries about graphene-sqlalchemy-filter HOT 2 CLOSED

from graphene_sqlalchemy_filter import FilterableConnectionField
from graphene_sqlalchemy_filter.connection_field import (
    FilterableFieldFactory, NestedFilterableConnectionField
)


class DisableDefaultSort:
    def __init__(self, connection, *args, **kwargs):
        kwargs.setdefault(
            "sort", connection.Edge.node._type.sort_argument(
                has_default=False
            )
        )
        super().__init__(connection, *args, **kwargs)


class MyNestedFilterableConnectionField(
    DisableDefaultSort,
    NestedFilterableConnectionField,
):
    pass


class CustomFilterableFieldFactory(FilterableFieldFactory):
    field_class = MyNestedFilterableConnectionField


class MyFilterableConnectionField(FilterableConnectionField):
    filters = {
        User: UserFilter(),
        Membership: MembershipFilter(),
        Group: GroupFilter(),
    }
    factory = CustomFilterableFieldFactory(filters)