What are good production ready alternatives for SQL? (That are still relational and doesn't make you rewrite half of the database logic again in each new backen

What are good production ready alternatives for SQL? (That are still relational and doesn't make you rewrite half of the database logic again in each new backend you make -- not talking about key/value stores)