Sqlite insert statement

I don’t really know what you mean by that.

Stored procedures on a database server. You can design them so that you just pass parameters to execute SQL statements instead of having in-line sql. MySQL Stored Procedure - w3resource

I only use SQLite so there is no server. I can see they might make sense for mySQL and the like.