Is it recommended to dedicate an entire method/function for formatting and preparing a MySQL query?

Question

MySQL

Suppose there is a method in which the result of completed forms is processed. After all, it would be incorrect to make a request inside the block for processing the entered data?
But if you create a method, then you need to pass the result of the forms to it.

Answer 1

That part of the code that works with the database should be connected with the rest of the code only by the set of data that it needs to save or read.
The application logic should not know anything about tables, queries, and so on. It only needs to know how to access the database wrapper to get or store data.
Any mixture of these two levels leads to shitcode - this has already been verified by several generations of pykhers.