Self hosting is definitely a plus. Only issue I have with that is if you want to use it as the backend for a native app, self hosting is going to cause you some serious anxiety.

SQL db is definitely easier to work with, and a better technology for POC work, but will cost a lot in the long run. Compare the cost of fully hosted SQL solutions like RDS to scalable document store solutions like DynamoDB and the benefits are pretty clear.

As with anything though, everything is situational. Supabase probably feels more familiar to most developers and that's worth a lot!