_sa_instance_state key and vaules being returned with my data

[yttcs]

First Check

• I added a very descriptive title here.
• I used the GitHub search to find a similar question and didn't find it.
• I searched the SQLModel documentation, with the integrated search.
• I already searched in Google "How to X in SQLModel" and didn't find any information.
• I already read and followed all the tutorial in the docs and didn't find an answer.
• I already checked if it is not related to SQLModel but to Pydantic.
• I already checked if it is not related to SQLModel but to SQLAlchemy.

Commit to Help

• I commit to help with one of those options 👆

Example Code

1. SQLModel:

class Customers(SQLModel, table=True):
    __tablename__ = "customers"
    customerNumber: Optional[int] = Field(primary_key=True)
    customerName: str
   # contactLastName: str
   # contactFirstName: str
   # phone: str
   # addressLine1: str
   # addressLine2: str
    city: str
   # state: str
   # postalCode: str
    country: str
   # creditLimit: str

2. FastAPI:

@router.get("/customers_get/")
async def read_customers(*, request: Request, session: Session = Depends(get_session)):
    result = session.query(Customers).all()
    return templates.TemplateResponse("index.html", {"request":request, "result": result})

3. Jinja2

<tr>
     {% for key in result[0] %}

      <th> {{ key[0] }} </th>
     {% endfor %}
  </tr>

<!-- table rows -->
  <tr>
  {% for row in result %}
     {% for value in row %}
     <td> {{ value[1] }} </td>
     {% endfor %}
  </tr>
  {% endfor %}

4. Result (five table headers instead of four)

_sa_instance_state country customerName city customerNumber

Description

I'm grabbing some records off a remote MariaDB database with FastAPI and SQLModel and displying them in a Jinja2 template. I'm getting my four expected keys and values (customerNumber, customerName, city, country), but I'm also getting an unexpected key:value pair (_sa_instance_state)

How do I avoid generating or including this data?

note: When I use the following FastAPI everything returns as expected (and in proper order):

@router.get("/customers/", response_model=list[Customers])
async def read_customers(*, session: Session = Depends(get_session)):
result = session.query(Customers).all()
return result

Operating System

Windows

Operating System Details

No response

SQLModel Version

0.0.8

Python Version

3.10.2

Additional Context

No response