sqlalchemy_loader to support multiple sessions

[gabor-lbl]

In my project, my graphql context has 2 db sessions:

'session': database.db_session,
'ro_session': database.ro_db_session,

For some read-only queries, I like to use ro_session which points to my read-only replica. However, afaict, the sqlalchemy_loader key can only point to one session. Would it be possible to somehow use the session an object was loaded with, instead of having to set sqlalchemy_loader?

In SqlAlchemy object_session() handles this.

Thank you!

Feature Request Type

• Core functionality
• Alteration (enhancement/optimization) of existing feature(s)
• New behavior

[Ckk3]

I think its a very nice feature! But probally we wont add it here since we are working on improving strawchemy to take place.

But if you create a PR I will review it ☺️

[gabor-lbl]

I will take a look at strawchemy as soon as my current project (converting a large codebase from graphene to strawberry) is done. Thanks!