What are the trade-offs between SQL and NoSQL databases for specific use cases in enterprise systems?