SAWarning from sqlalchemy

[poupryc]

First Check

• I added a very descriptive title to this issue.
• I used the GitHub search to find a similar issue 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

No code

Description

Every time I use the SQLModel ORM, I get this warning.

/.../sqlmodel/orm/session.py:60: SAWarning: Class SelectOfScalar will not make use of SQL compilation caching as it does 
not set the 'inherit_cache' attribute to ``True``. This can have significant performance implications including some 
performance degradations in comparison to prior SQLAlchemy versions. Set this attribute to True if this object can make 
use of the cache key generated by the superclass. Alternatively, this attribute may be set to False which will disable this 
warning. (Background on this error at: https://sqlalche.me/e/14/cprf)
 results = super().execute(

A link is given.

Operating System

Linux

Operating System Details

Linux 5.15.7-arch1-1 x86_64 GNU/Linux

SQLModel Version

0.0.4

Python Version

Python 3.9.9

Additional Context

The only other reference to this problem that I have found is this one
#129 (comment)

[postpersonality]

I've solved mine by importing select() from sqlalchemy directly.

[BurnySc2]

I've solved mine by importing select() from sqlalchemy directly.

Be aware that if you select a single value, you will still get a tuple in return, e.g.:

# with 'select' from sqlmodel
with Session(engine) as session:
 count_statement = select(func.count()).select_from(Book).where(Book.release_year < 1960)
 amount = session.exec(count_statement).first()
 assert amount == 2

This needs to be assert amount == (2, ) if you use the select from sqlalchemy.

[mfrey777]

Is importing select() from sqlalchemy really a solution to this, it don't see the point of using SQLModel and then bypassing it on all select statements. ? Is there a parameter/settings that need to be set somewhere to activating the caching ?

[chriswhite199]

While i can't tell you why, the following amendment resolves this warning for me:

# raises the SAWarning
session.query(MyModel).where(MyModel.field1 == 'value').first()

# Does not raise the warning
from sqlmodel import col
session.query(MyModel).where(col(MyModel.field1) == 'value').first()

[curtwagner1984]

Is importing select() from sqlalchemy really a solution to this, it don't see the point of using SQLModel and then bypassing it on all select statements. ? Is there a parameter/settings that need to be set somewhere to activating the caching ?

Did you find an answer?

While i can't tell you why, the following amendment resolves this warning for me:

# raises the SAWarning
session.query(MyModel).where(MyModel.field1 == 'value').first()

# Does not raise the warning
from sqlmodel import col
session.query(MyModel).where(col(MyModel.field1) == 'value').first()

What happens when you don't need a col? Like in :

with Session(engine) as session:
 stmt = select(MyModel)
 results = session.exec(stmt).all()

[Gladrat]

I haven't found any way to disable caching for now.
And the same issue occurs even when not using col.

[Data-Zen]

I am having the same issue. Fix needed ASAP.

[angel-langdon]

Same issue

[cazdlt]

Same here :)

[Tombrilluin]

Same issue...

[maresb]

Hi everyone, please stop replying with "same" without contributing more info, that is what the 👍 button at the top is for. Doing so generates spam for everyone who is subscribed, and wastes the valuable time of people like tiangolo.

Using the 👍 button in this way is generally considered good etiquette across all of GitHub. Thanks, and I also hope that someone comes up with a solution soon. 😃

EDIT: LOL, what is going on here? Is this GitHub or Facebook? I'm not sure whether or not @mmlynarik is trolling. 😂 I'm just subscribed to this thread, hoping for a solution, and getting mildly disappointed each time I receive a notification for a pointless message. I'm not particularly motivated to try and solve this issue myself. I do however have a suggestion...

If you are so eager for tiangolo to fix this issue, then rather than spamming him, please consider showing him some ❤️ with the Sponsor button at the bottom. I'd really love to see FOSS maintainer become a more viable career choice.

[mmlynarik]

Hi everyone, please stop replying with "same" without contributing more info, that is what the 👍 button at the top is for. Doing so generates spam for everyone who is subscribed, and wastes the valuable time of people like tiangolo.

Using the 👍 button in this way is generally considered good etiquette across all of GitHub. Thanks, and I also hope that someone comes up with a solution soon. 😃

@maresb do you know what is the reason for the warning? Maybe @tiangolo could drop here some hint what could have gone wrong...