re: ORM vs Query Builders vs Raw SQL VIEW POST

re: Does anyone have experience with having the most used queries as stored procedures on the database side?

Good question and definitely one that struck me whilst looking into this more.

If I move towards utilising more raw SQL, then really I've made some assumptions on the type of DB I'm going to be working against, therefore most of this could be moved to the DB as procedures or even views.

In some ways I can see that I'm dumbing down my application to be more concerned with working with defined interfaces, but I'm maybe losing some control / flexibility too.

code of conduct - report abuse