For further context, I'm responding to someone who is advocating putting your business layer in your database.

I'm not against using tools that exist to make accessing your database more efficient - including recursive queries. I'm against making your database responsible for more of your application than it needs to be.