`force_debug_cursor` does nothing in async

[James Ostrander]

Django version: 4.2.11
Python version: 3.12

Settings:

DEBUG=False

For Pytest, where DEBUG=False, this removes a means of enabling query logging via override.

SYNC VIEW (WORKING):

def query_test_sync(request: HttpRequest) -> HttpResponse:
    from django.db import connection

    connection.force_debug_cursor = True

    a = Thing.objects.first()
    return HttpResponse(f"First thing: {a.id}")

Log:

web-1       | [18/Apr/2024 14:48:35] "GET /test_query_sync/ HTTP/1.1" 200 31
web-1       | (0.001) SELECT "thing_thing"."name", "thing_thing"."id" FROM "thing_thing" ORDER BY "thing_thing"."id" ASC LIMIT 1; args=(); alias=default

ASYNC VIEW (NOT WORKING):

async def query_test_async(request: HttpRequest) -> HttpResponse:
    from django.db import connection

    connection.force_debug_cursor = True

    a = await Thing.objects.afirst()
    return HttpResponse(f"First thing: {a.id}")

Log:

web-1       | [18/Apr/2024 15:00:29] "GET /test_query_async/ HTTP/1.1" 200 31

Also worth noting: CaptureQueriesContext does not work in an async context.