Because on peak traffic you could have thousands of cloud functions running, each with its own connection to the database. Typically SQL databases are much more strict on the number of concurrent connections as these consume more memory than on NoSql databases.

Edit:

IIRC I read that each connection to Postgres consumes 10MB or RAM.