Interesting. We have totally different philosophies here. 1. Moving logic out of SQL can break transactionality and hurt performance (more data leaves the DB)

Interesting. We have totally different philosophies here. 1. Moving logic out of SQL can break transactionality and hurt performance (more data leaves the DB) 2. ORMs hide the SQL from you, making all sorts of other things harder My favoured approach is to test my application against a real local database, built from a fresh snapshot each time. I do not change my application code to make testing easier. The application code is optimised for maintainability - so simplicity and ease of reading.