In certain use cases, we need to connect to two different databases or to two different schemas in the same database. This allows users to keep functional components separate. I understand that this is not possible to represent in content builder, but this functionality doesn't need to be viewed on the Strapi admin UI, it can exist as it did in V3 of Strapi.
An example is when you have the main database/schema for business logic, user data and functionality related data. Strapi has complete visibility over this (including in content builder).
Another database/schema can be used to view analytics. This analytics db/schema can have dimensional data and can follow a star schema structure where analytics and business intelligence can be best presented. the dimensional tables can exist without representation in Strapi Admin UI, but users can write data to the fact table/tables via the second connection.
Strapi V3 had this feature.