Comparing datetime fields doesn't filter out rows

[eric369java]

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

# model.py
class Activity(SQLModel, table=True):
    id: uuid_pkg.UUID = Field(default_factory=uuid_pkg.uuid4, primary_key=True)
    schedule_id: uuid_pkg.UUID = Field(nullable=False, foreign_key='schedule.id')
    title: str = Field(nullable=False)
    type: str = Field(default='Default', nullable=False)
    cost: str | None = Field(nullable=True) #'ex. 100 USD'
    time_start_UTC: datetime = Field(nullable=False)
    time_end_UTC: datetime = Field(nullable=False)
    location: str = Field(nullable=False)
    local_timezone: int = Field(default=0, nullable=False) # timezone +/- hours from UTC
    dest_location : str | None = Field(nullable=True) # only populated if type = transit.

# query snippet (in my code there is no newline between < and end_of_current_week)
activities = self.db_session.exec(select(Activity).where(Activity.schedule_id == schedule_id \
                and Activity.time_start_UTC >= current_week and Activity.time_end_UTC < end_of_current_week).order_by(Activity.time_start_UTC)).all()

Description

Hi, I'm trying to retrieve all activities whose time_start_UTC and time_end_UTC fall between current_week and end_of_current_week (they are both datetime objects in Python. current_week is 2025-06-22 00:00:00 and end_of_current_week is 2025-06-29 00:00:00).

As you can see from the image below, the activity with title 'Shibuya Scramble Crossing' should have been filtered out by the query because its time_end_UTC comes after 2025-06-29 00:00:00. However, when I run the query it returns both rows in the table. For context I am using PostgreSQL.

Am I comparing datetime fields incorrectly ? Please help me identify the issue.

Operating System

Windows

Operating System Details

No response

SQLModel Version

0.0.24

Python Version

3.13.2

Additional Context

No response

[eric369java]

Actually, it seems putting anything (Activity.title == "not a valid title") in the WHERE clause is not filtering any rows.

[eric369java]

Closed, realize you cant use Python and. Sorry