Accessing db.session from Django app

[alik472]

Hi, I am trying to query a subquery in Django, and in my Flask app I used to query like this:

db.session.query(some_subquery)

How can I access session instance or alternatively how can I do the same query from Model?

I have tried this:

some_subquery.sa.query()
and
some_subquery.query()

Both throwing an exception of attribute/method does not exist.

Please help.

[alik472]

After some googling I found this link.
https://rodic.fr/blog/sqlalchemy-django/

I have implemented the session instance this way, but I am not sure it is the best way:

from sqlalchemy.orm import sessionmaker
from aldjemy.core import get_engine

def Session():
    engine = get_engine()
    _Session = sessionmaker(bind=engine)
    return _Session()

session = Session()

session.query(some_subquery)