For the average developer just starting out, pick Aurora Serverless (MySQL or Postgres). It's probably all you will ever need. Relational databases are still the best general purpose thing out there.