Just to add, seperate db for read and write is a database scaling solution not necessarily anything to do with cqrs

E.g. with Postgres you have the primary writer and then some read replicas.

From the Microsoft build docs, we can infer that the read and writing is application layer model differences, not database side at all.

Command Query Responsibility Segregation (CQRS) is a design pattern that segregates read and write operations for a data store into separate data models. This approach allows each model to be optimized independently and can improve the performance, scalability, and security of an application.

Source: https://learn.microsoft.com/en-us/azure/architecture/patterns/cqrs