Supabase developer here: keep in mind that, while PostgreSQL is unapologetically SQL-based, it's support for JSON and JSONB fields give it a lot of the powers of NoSQL. These days the lines are becoming more blurred.

Here's an article I wrote with a basic introduction to the NoSQL features of PostgreSQL: https://supabase.com/blog/sql-or-nosql-both-with-postgresql