Django raw () request with similar code "tuple" has no "id" attribute

I am making multiple queries and then removing duplicates by rank for a graveyard burial application. I am trying to use PostgreSQL SIMILAR TO in my latest search ranking, but every time I use it, I get that the "tuple" object has no "id" attribute.

Here are two queries:

query1 = """
            SELECT "burials_burial"."id", "burials_burial"."name_id",
                "burials_burial"."grave_id",
                "burials_burial"."interment_date",
                "burials_burial"."user_id",
                "cemeteries_grave"."search1_id" AS "cemetery_id",
                '2' AS "rank"
            FROM "burials_burial"
            INNER JOIN "names_name"
                ON ( "burials_burial"."name_id" = "names_name"."id" )
            INNER JOIN "cemeteries_grave"
                ON ( "burials_burial"."grave_id" =
                    "cemeteries_grave"."id")
            WHERE (
                (LOWER("names_name"."first_name") IN {0!s})
                OR (LOWER("names_name"."middle_name") IN {0!s})
                OR (LOWER("names_name"."last_name") IN {0!s})
            )
        """

query2 = """
            SELECT "burials_burial"."id", "burials_burial"."name_id",
                "burials_burial"."grave_id",
                "burials_burial"."interment_date",
                "burials_burial"."user_id",
                "cemeteries_grave"."search1_id" AS "cemetery_id",
                '1' AS "rank"
            FROM "burials_burial"
            INNER JOIN "names_name"
                ON ( "burials_burial"."name_id" = "names_name"."id" )
            INNER JOIN "cemeteries_grave"
                ON ( "burials_burial"."grave_id" =
                    "cemeteries_grave"."id")
            WHERE (
                (LOWER("names_name"."first_name") SIMILAR TO {0!s})
                OR (LOWER("names_name"."middle_name") SIMILAR TO {0!s})
                OR (LOWER("names_name"."last_name") SIMILAR TO {0!s})
            )
        """

      

        
        
        
      

    

When I call the queries I provide in the relevant search parameters here:

names1 = Burial.objects.raw(query1.format(terms))
names2 = Burial.objects.raw(query2.format(terms.replace('\'', '').replace(', ', '|').replace('(', '\'%(').replace(')', ')%\'')))

      

        
        
        
      

    

Finally, I'm just trying to view the names and do something with them:

for names in (names1, names2):
    for n in names:
        <do something here>

      

        
        
        
      

    

Now that things are strange. For names1 I am getting my results and I can skip them. For names 2, I am getting the error noted above. Why?

I have looked at the output of the raw queries to ensure that what I am shipping to PostgreSQL is indeed. Executing queries as python shell output gives me the results as I expect:

IN: print names1.raw_query

OUT: SELECT "burials_burial"."id", "burials_burial"."name_id",
                        "burials_burial"."grave_id",
                        "burials_burial"."interment_date",
                        "burials_burial"."user_id",
                        "cemeteries_grave"."search1_id" AS "cemetery_id",
                        '25' AS "rank"
                    FROM "burials_burial"
                    INNER JOIN "names_name"
                        ON ( "burials_burial"."name_id" = "names_name"."id" )
                    INNER JOIN "cemeteries_grave"
                        ON ( "burials_burial"."grave_id" =
                            "cemeteries_grave"."id")
                    WHERE (
                        LOWER("names_name"."first_name") IN ('william', 'david', 'smith')
                        AND LOWER("names_name"."middle_name") IN ('william', 'david', 'smith')
                    )
IN: print names2.raw_query

OUT: SELECT "burials_burial"."id", "burials_burial"."name_id",
                    "burials_burial"."grave_id",
                    "burials_burial"."interment_date",
                    "burials_burial"."user_id",
                    "cemeteries_grave"."search1_id" AS "cemetery_id",
                    '1' AS "rank"
                FROM "burials_burial"
                INNER JOIN "names_name"
                    ON ( "burials_burial"."name_id" = "names_name"."id" )
                INNER JOIN "cemeteries_grave"
                    ON ( "burials_burial"."grave_id" =
                        "cemeteries_grave"."id")
                WHERE (
                    (LOWER("names_name"."first_name") SIMILAR TO '%(william|david|smith)%')
                    OR (LOWER("names_name"."middle_name") SIMILAR TO '%(william|david|smith)%')
                    OR (LOWER("names_name"."last_name") SIMILAR TO '%(william|david|smith)%')
                )

      

        
        
        
      

    

I have also used a cursor directly with the query and return the results, although not as objects, so this is not ideal. But this shows that python / django can handle the request:

IN: from django.db import connections
IN: cursor = connection.cursor()
IN: cursor.execute(names2.raw_query)
IN: results = cursor.fetchall()
IN: len(results)

OUT: 1

      

        
        
        
      

    

So again, my question is. Why does the seemingly valid request give me a "tuple" object, doesn't have an id attribute error?