Sqlalchemy Warning Textual Column Expression Should Be Explicitly Declared?

I faced this issue and I think the problem happens when you do not provide a condition on filter(), e.g instead of declaring filter(model.Email == EmailInput) you declare filter(EmailInput)

It seems that you're encountering an issue related to the syntax of your SQLAlchemy query. The error message is suggesting that the column needs to be explicitly defined. Allow me to clarify the correct approach to addressing this issue:

The error arises when you try to include a condition directly within the SQLAlchemy query. Here's an illustration of the incorrect query syntax:

# This query syntax will result in an error
return session.query(cls).filter(
    cls.corelation_id == corelation_id,
    cls.status == cls.ORDER_ACTIVE if not is_cancel else cls.ORDER_CANCEL
).first()

However, the correct way to handle this is by first defining the status condition using a separate variable. Here's the accurate approach:

# Define the status condition based on the 'is_cancel' flag
status = cls.ORDER_ACTIVE if not is_cancel else cls.ORDER_CANCEL

# Use the defined status condition in the SQLAlchemy query
return session.query(cls).filter(
    cls.corelation_id == corelation_id,
    cls.status == status
).first()

In case someone is using where clause, Please make sure you are creating a condition and not just passing the arguments e.g.

from sqlalchemy.orm import Session,aliased
from sqlalchemy import Boolean, Column, DateTime, Integer, String, select,label,func,text,literal_column

 u = aliased(User)
 q = select(u.id).select_from(u).where(u.username == user.username)

Check out

where(u.username == user.username)

I was having the following line

where(u.username, user.username)

and it comes out, it should be

where(u.username == user.username)

This warning (or ArgumentError, from v1.3 onwards) is raised when a column name is passed to select (or other functions) as a raw string. Similar warnings may be raised for similar actions, such as passing table names or the right hand side of where/filter calls passed as text. In this answer I am using SQLAlchemy 2.0 syntax, as 1.2.x is no longer supported*.

For example, this

import sqlalchemy as sa

query = sa.select('name').select_from('users')

would raise two exceptions (were that possible), one for the column name in select and one for the table name in select_from.

ArgumentException: Textual column expression 'name' should be explicitly declared with text('name'), or use column('name') for more specificity
ArgumentException: Textual SQL FROM expression 'users' should be explicitly declared as text('users'), or use table('users') for more specificity 

The warning can be addressed by wrapping the strings with the text function:

query = sa.select(sa.text('name')).select_from(sa.text('users'))

or, as the warnings suggests, with column and table functions that make the strings' targets more specific:

query = sa.select(sa.column('name')).select_from(sa.table('users'))

* The differences, for the purpose of this answer are:

• ArgumentExcaption is raised rather than SAWarning
• Pre-2.0, select expects a list of arguments, like sa.select(['name'])