When should you pick SQL over NoSQL for user profiles,

hey everyone, im working on a new project and struggling with a common decision: user profile storage. we're expecting a lot of users, and profiles can have varying fields depending on user type, like basic users, premium users, or enterprise clients. should we lean towards a traditional SQL database like PostgreSQL, or a NoSQL option like MongoDB or Cassandra? im weighing the flexibility of NoSQL for evolving schemas against the structured querying capabilities of SQL. what factors have guided your decisions in similar scenarios?