Methods or functions for working with the database through SQLAlchemy?

Question

Flask

I'm making an API in Flask.
There was a question: how it is better to work with a DB through ORM SQLAlchemy?
1. Write functions in the routes
db.query...
db.add(data)
db.commit

You can, as an option, move the functions to a separate services file

2. Write methods in the alchemy table model classes.

Both options are working.
But why are methods in classes better?

Answer 1

You write common requests that can be repeated many times in the code in the model class so that you don’t duplicate the code later, everything else is in place, that is, in the routes themselves. Putting 1-2 lines of code into some separate file, which are used 1 time in 1 place - such an idea.