can you elaborate on what "overly SQL heavy" even means? it's just a postgres db as a service, use as much or as little as you want

The authn/authz is heavily tied to PSQL. It lacks the polish and ease of use of Firebase. It takes too much configuration to get started. Poor support for things like migrations management and generation.