Comment by dehugger
1 month ago
Sounds like your issue is writing the complex SQL all as strings in your codebase instead of as functions in the database.
1 month ago
Sounds like your issue is writing the complex SQL all as strings in your codebase instead of as functions in the database.
No issue at all. There is a place for stored procs and functions in cases where you need to do things an ORM is not capable of. It is an exception, not a rule. Managing procs/functions is overhead and has the same if not more maintenance headaches than raw SQL strings in code.