PgSQL because of full phat functionality.

What would be an example of where you prefer postgres over something else? What's your favorite part of the syntax?

https://www.postgresql.org/docs/14/arrays.html

The full-text functionality kicks ass

https://www.postgresql.org/docs/14/textsearch.html

It can query JSON and XML documents directly

https://www.postgresql.org/docs/14/datatype-json.html https://www.postgresql.org/docs/14/functions-xml.html

It supports stored procedures

https://www.postgresql.org/docs/14/plpgsql.html

The extension mechanisms are very powerful, if you are interested doing nearest-neighbor vector search like Pinecone or FAISS (super hot today) you can install

https://github.com/pgvector/pgvector

Adding it all up, pgsql has a lot of the functionality you'd expect in a database like Oracle but it is also a product engineering managers love because it is highly reliable and easy to maintain.