What is the best way to execute SQL?

Question

Python

There is a need to delete data from tables, create tables, the question is how best to implement this, what will be faster?
Call queries directly:

dbcur.execute = f"""DELETE FROM table_test WHERE mont = {mont}"""

or better via stored procedures:
dbcur.execute(f"EXECUTE DELETE_TABLE('{mont}')")

Answer 1

The stored procedure has an already compiled query plan (in MS SQL, Sybase this is exactly the case).
Theoretically, if the query is complex, the stored procedure will be faster by the time it takes the optimizer to build the plan.
But practically, on single queries, there will be no visible difference.

Answer 2

Equally.