async Select error

[FloareDor]

register user

TypeError: object Select can't be used in 'await' expression

It's working if I remove await in this line: query = await self._query(join_)

or if I change the _query function to async.

what do you suggest, lord

also, do you the code and structure are still production-ready? what do you think of a monolithic folder structure like this:

https://github.com/zhanymkanov/fastapi-best-practices

Also, I'd love to know about when to use Transactional and Propogation new