How do SQL and NoSQL databases differ in terms of consistency, scalability, and use cases within a banking ecosystem?