Is it possible to start the workflow for an entity (e.g. request) using a stored procedure in the database?
This is not possible. The workflow is implemented as a set of .Net classes which cannot be called easily from the database. Use the API instead to create new objects and to start their workflow.