How to get row number in Flask-sqlalchemy table?

Question

Python

Hello, I need help. I'm using the flask-sqlalchemy extension. Here's the link . I have a table of players in which everyone has a rating, the rating is just an integer. I found how to sort in descending order.

query = Player.query.order_by(Player.rating.desc()).all()

For example, I have a player with id=52, how can I find out what place he occupies in the sorted query?

Answer 1

and what prevents to count a position in query of this id?