Both decent approaches and we reduced a lot of friction by using code generation. Unfortunately, modern development favors having all logic on the application

Both decent approaches and we reduced a lot of friction by using code generation. Unfortunately, modern development favors having all logic on the application side. There are a lot of benefits that brings including better testing (stored proc testing frameworks never really caught on) however I find now a lot of people I work with rely too heavily on the ORM and don't know how to work with the databases (writing sub optimal queries, not properly indexing, etc)