Have you created functions or stored procedures inside the database?

In my practice, I have not created functions or stored procedures directly inside the database, as I mostly worked with business logic at the application level. However, I am familiar with stored procedures and understand their advantages, such as improving performance by executing logic on the database side and reducing network traffic.

If needed, I can quickly learn how to create and optimize such procedures, for example, in SQL or PL/pgSQL.