If you’re going this way, might as well put all of that as a stored procedure in the database. At least it Simplifies your infrastructure.